https://dev-inventory.voom.co.nz/admin/calculator_product_business_card/edit/37

Query Metrics

10 Database Queries
9 Different statements
2.74 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.13 ms
(41.33%)
1
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
]
0.37 ms
(13.33%)
1
SELECT t0.id AS id_1, t0.finished_size_x AS finished_size_x_2, t0.finished_size_y AS finished_size_y_3, t0.side_one AS side_one_4, t0.side_two AS side_two_5, t0.name AS name_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.calculator_product_business_card_id AS calculator_product_business_card_id_9, t0.machine_id AS machine_id_10, t0.paper_size_id AS paper_size_id_11, t0.imposition_id AS imposition_id_12, t0.printing_type_id AS printing_type_id_13, t0.paper_type_id AS paper_type_id_14 FROM business_card_option t0 WHERE t0.calculator_product_business_card_id = ?
Parameters:
[
  37
]
0.35 ms
(12.74%)
1
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.setup AS setup_6, t0.cost AS cost_7, t0.setup_description AS setup_description_8, t0.cost_description AS cost_description_9, t0.invoice_description_description AS invoice_description_description_10, t0.technical_notes_description AS technical_notes_description_11, t0.cost_matrix_description AS cost_matrix_description_12, t0.time_matrix_description AS time_matrix_description_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.label_id AS label_id_16, t0.imposition_id AS imposition_id_17 FROM task t0 INNER JOIN business_card_option_task ON t0.id = business_card_option_task.task_id WHERE business_card_option_task.business_card_option_id = ?
Parameters:
[
  75
]
0.27 ms
(9.97%)
1
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.id = ?
Parameters:
[
  "37"
]
0.20 ms
(7.27%)
2
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
]
0.11 ms
(4.09%)
1
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
]
0.11 ms
(4.08%)
1
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:
[
  4603
]
0.11 ms
(3.91%)
1
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
]
0.09 ms
(3.29%)
1
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
]

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\CalculatorProductBusinessCard No errors.
App\Entity\Calculator 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.
App\Entity\Machine No errors.
App\Entity\PaperSize No errors.
App\Entity\Imposition 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\ProductField No errors.
App\Entity\ProductIn No errors.
App\Entity\Label No errors.
App\Entity\TaskCostMatrix No errors.
App\Entity\TaskTimeMatrix No errors.
App\Entity\PriceMatrix No errors.