https://dev-inventory.voom.co.nz/admin/calculator/2/show Return to referer URL

Query Metrics

20 Database Queries
14 Different statements
2.76 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.17 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM user t0 WHERE t0.id = ?
Parameters:
[
  18
]
2 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.template AS template_4, t0.admin_base_fee AS admin_base_fee_5, t0.sales_base_fee AS sales_base_fee_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM calculator t0 WHERE t0.id = ?
Parameters:
[
  "2"
]
3 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.invoice_description AS invoice_description_4, t0.technical_notes AS technical_notes_5, t0.waste AS waste_6, t0.spoilage AS spoilage_7, t0.setup_time AS setup_time_8, t0.rate AS rate_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_id AS parent_id_12 FROM machine t0 WHERE t0.id = ?
Parameters:
[
  4
]
4 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.invoice_description AS invoice_description_4, t0.technical_notes AS technical_notes_5, t0.waste AS waste_6, t0.spoilage AS spoilage_7, t0.setup_time AS setup_time_8, t0.rate AS rate_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_id AS parent_id_12 FROM machine t0 WHERE t0.id = ?
Parameters:
[
  2
]
5 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.description AS description_4, t0.width AS width_5, t0.height AS height_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM paper_size t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.paper_size_across AS paper_size_across_3, t0.paper_size_down AS paper_size_down_4, t0.imposition_across AS imposition_across_5, t0.imposition_down AS imposition_down_6, t0.no_across_to_print AS no_across_to_print_7, t0.gutter_across AS gutter_across_8, t0.gutter_down AS gutter_down_9, t0.no_down_to_print AS no_down_to_print_10, t0.no_up AS no_up_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM imposition t0 WHERE t0.id = ?
Parameters:
[
  1
]
7 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.qty AS qty_4, t0.code AS code_5, t0.description AS description_6, t0.hold AS hold_7, t0.shop_stock AS shop_stock_8, t0.size AS size_9, t0.color AS color_10, t0.gsm AS gsm_11, t0.caliper_microns AS caliper_microns_12, t0.dimension1 AS dimension1_13, t0.dimension2 AS dimension2_14, t0.broken_rate AS broken_rate_15, t0.packet_rate AS packet_rate_16, t0.packet_qty AS packet_qty_17, t0.bulk_rate AS bulk_rate_18, t0.bulk_qty AS bulk_qty_19, t0.pricing_units AS pricing_units_20, t0.sheet_reel_envelope AS sheet_reel_envelope_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.product_type_id AS product_type_id_24 FROM product t0 WHERE t0.id = ?
Parameters:
[
  5398
]
8 0.14 ms
SELECT t0.id AS id_1, t0.setup AS setup_2, t0.rate AS rate_3, t0.colour_click_label AS colour_click_label_4, t0.black_only_click_label AS black_only_click_label_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.machine_id AS machine_id_8, t0.paper_size_id AS paper_size_id_9 FROM machine_paper_size_matrix t0 WHERE t0.paper_size_id = ? AND t0.machine_id = ? LIMIT 1
Parameters:
[
  1
  2
]
9 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.qty AS qty_4, t0.code AS code_5, t0.description AS description_6, t0.hold AS hold_7, t0.shop_stock AS shop_stock_8, t0.size AS size_9, t0.color AS color_10, t0.gsm AS gsm_11, t0.caliper_microns AS caliper_microns_12, t0.dimension1 AS dimension1_13, t0.dimension2 AS dimension2_14, t0.broken_rate AS broken_rate_15, t0.packet_rate AS packet_rate_16, t0.packet_qty AS packet_qty_17, t0.bulk_rate AS bulk_rate_18, t0.bulk_qty AS bulk_qty_19, t0.pricing_units AS pricing_units_20, t0.sheet_reel_envelope AS sheet_reel_envelope_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.product_type_id AS product_type_id_24 FROM product t0 WHERE t0.id = ?
Parameters:
[
  5398
]
10 0.11 ms
SELECT t0.id AS id_1, t0.setup AS setup_2, t0.rate AS rate_3, t0.colour_click_label AS colour_click_label_4, t0.black_only_click_label AS black_only_click_label_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.machine_id AS machine_id_8, t0.paper_size_id AS paper_size_id_9 FROM machine_paper_size_matrix t0 WHERE t0.paper_size_id = ? AND t0.machine_id = ? LIMIT 1
Parameters:
[
  1
  2
]
11 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.invoice_description AS invoice_description_4, t0.technical_notes AS technical_notes_5, t0.waste AS waste_6, t0.spoilage AS spoilage_7, t0.setup_time AS setup_time_8, t0.rate AS rate_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_id AS parent_id_12 FROM machine t0 WHERE t0.id = ?
Parameters:
[
  "16"
]
12 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.paper_size_across AS paper_size_across_3, t0.paper_size_down AS paper_size_down_4, t0.imposition_across AS imposition_across_5, t0.imposition_down AS imposition_down_6, t0.no_across_to_print AS no_across_to_print_7, t0.gutter_across AS gutter_across_8, t0.gutter_down AS gutter_down_9, t0.no_down_to_print AS no_down_to_print_10, t0.no_up AS no_up_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM imposition t0 WHERE t0.id = ?
Parameters:
[
  "72"
]
13 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.description AS description_4, t0.width AS width_5, t0.height AS height_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM paper_size t0 WHERE t0.id = ?
Parameters:
[
  "7"
]
14 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.description AS description_4, t0.price AS price_5, t0.price_top AS price_top_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.calculator_id AS calculator_id_9 FROM calculator_product_business_card t0 WHERE t0.code = ? LIMIT 2
Parameters:
[
  "Trade foiling A5 - 1 pos"
]
15 0.13 ms
SELECT t0.id AS id_1, t0.start_qty AS start_qty_2, t0.admin AS admin_3, t0.sales AS sales_4, t0.overheads AS overheads_5, t0.profit AS profit_6, t0.profit_top AS profit_top_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.calculator_id AS calculator_id_10 FROM price_matrix t0 WHERE t0.calculator_id = ?
Parameters:
[
  2
]
16 0.12 ms
SELECT t0.id AS id_1, t0.setup AS setup_2, t0.rate AS rate_3, t0.colour_click_label AS colour_click_label_4, t0.black_only_click_label AS black_only_click_label_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.machine_id AS machine_id_8, t0.paper_size_id AS paper_size_id_9 FROM machine_paper_size_matrix t0 WHERE t0.machine_id = ?
Parameters:
[
  16
]
17 0.17 ms
SELECT t0.id AS id_1, t0.start_qty AS start_qty_2, t0.rate AS rate_3, t0.setup_time AS setup_time_4, t0.machine_id AS machine_id_5 FROM machine_time_matrix t0 WHERE t0.machine_id = ?
Parameters:
[
  16
]
18 0.16 ms
SELECT t0.id AS id_1, t0.start_qty AS start_qty_2, t0.cost AS cost_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.machine_id AS machine_id_6 FROM machine_cost_matrix t0 WHERE t0.machine_id = ?
Parameters:
[
  16
]
19 0.14 ms
SELECT t0.id AS id_1, t0.start_qty AS start_qty_2, t0.time AS time_3, t0.rate AS rate_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.machine_paper_size_matrix_id AS machine_paper_size_matrix_id_7 FROM machine_paper_size_time_matrix t0 WHERE t0.machine_paper_size_matrix_id = ?
Parameters:
[
  29
]
20 0.12 ms
SELECT t0.id AS id_1, t0.start_qty AS start_qty_2, t0.cost AS cost_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.machine_paper_size_matrix_id AS machine_paper_size_matrix_id_6 FROM machine_paper_size_cost_matrix t0 WHERE t0.machine_paper_size_matrix_id = ?
Parameters:
[
  29
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\ProductImport No errors.
App\Entity\ProductOut No errors.
App\Entity\IncomingOrder No errors.
App\Entity\Calculator No errors.
App\Entity\PriceMatrix No errors.
App\Entity\CalculatorProductBusinessCard No errors.
App\Entity\Imposition No errors.
App\Entity\Machine No errors.
App\Entity\PaperSize No errors.
App\Entity\Product No errors.
App\Entity\Task No errors.
App\Entity\MachinePaperSizeMatrix No errors.
App\Entity\MachineCostMatrix No errors.
App\Entity\MachineTimeMatrix No errors.
App\Entity\ProductType No errors.
App\Entity\MachinePaperSizeCostMatrix No errors.
App\Entity\MachinePaperSizeTimeMatrix No errors.
App\Entity\MachinePaperSizeBlackOnlyClickMatrix No errors.
App\Entity\BusinessCardOption
  • The association App\Entity\BusinessCardOption#machine refers to the inverse side field App\Entity\Machine#businessCardOptions which does not exist.
  • The association App\Entity\BusinessCardOption#tasks refers to the inverse side field App\Entity\Task#businessCardOptions which does not exist.
  • The association App\Entity\BusinessCardOption#printingType refers to the inverse side field App\Entity\Machine#businessCardOptions which does not exist.
  • The association App\Entity\BusinessCardOption#paperType refers to the inverse side field App\Entity\Product#businessCardOptions which does not exist.