GET https://moonprint.cod3lab.eu/product/11

Response
200 OK
IP
216.73.216.103
Profiled on
Token
855f0a

Query Metrics

20 Database Queries
14 Different statements
51.27 ms Query time
0 Invalid entities
213 Managed entities

Queries

Group similar statements

#▲ Time Info
1 2.55 ms 
SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.name AS name_3, t0.title AS title_4, t0.specification AS specification_5, t0.description AS description_6, t0.visible AS visible_7, t0.source_id AS source_id_8, t0.manufacturer_id AS manufacturer_id_9, t0.remote_category_id AS remote_category_id_10 FROM product t0 WHERE t0.id = ?
Parameters: 
[
  "11"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 7.51 ms 
SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.name AS name_2, a0_.visible AS visible_3, a0_.position AS position_4, a0_.depth AS depth_5, a0_.sort_path AS sort_path_6, a0_.parent_id AS parent_id_7 FROM attribute a0_ INNER JOIN attribute_value a1_ ON a0_.id = a1_.attribute_id INNER JOIN product_variant_attribute_value p2_ ON a1_.id = p2_.attribute_value_id INNER JOIN product_variant p3_ ON p2_.variant_id = p3_.id INNER JOIN product p4_ ON p3_.product_id = p4_.id WHERE p4_.id = ? AND p4_.visible = true AND p3_.visible = true AND a0_.visible = true GROUP BY a0_.id ORDER BY a0_.sort_path ASC
Parameters: 
[
  11
]
View formatted query    View runnable query    Explain query    View query backtrace
3 4.20 ms 
SELECT a0_.id AS id_0, a0_.value AS value_1, a0_.value_float AS value_float_2, a0_.attribute_id AS attribute_id_3 FROM attribute_value a0_ INNER JOIN attribute a1_ ON a0_.attribute_id = a1_.id INNER JOIN product_variant_attribute_value p2_ ON a0_.id = p2_.attribute_value_id INNER JOIN product_variant p3_ ON p2_.variant_id = p3_.id INNER JOIN product p4_ ON p3_.product_id = p4_.id WHERE p4_.id = ? AND p4_.visible = true AND p3_.visible = true AND a1_.id = ? GROUP BY a0_.id, a0_.value, a0_.value_float, a0_.attribute_id
Parameters: 
[
  11
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.76 ms 
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters: 
[
  11
]
View formatted query    View runnable query    Explain query    View query backtrace
5 3.57 ms 
SELECT a0_.id AS id_0, a0_.value AS value_1, a0_.value_float AS value_float_2, a0_.attribute_id AS attribute_id_3 FROM attribute_value a0_ INNER JOIN attribute a1_ ON a0_.attribute_id = a1_.id INNER JOIN product_variant_attribute_value p2_ ON a0_.id = p2_.attribute_value_id INNER JOIN product_variant p3_ ON p2_.variant_id = p3_.id INNER JOIN product p4_ ON p3_.product_id = p4_.id WHERE p4_.id = ? AND p4_.visible = true AND p3_.visible = true AND a1_.id = ? AND p3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  11
  1
  525
  526
  527
  528
  529
  530
  531
  532
  533
  534
  535
  536
  537
  538
  539
  540
  541
  542
  543
  544
  545
  546
  547
  548
  549
  550
  551
  552
  553
  554
  555
  556
  557
  558
  559
  560
  561
  562
  563
  564
  565
  566
  567
  568
  569
  570
  571
  572
  573
  574
  575
  576
  577
  578
  579
  580
  581
  582
  583
  584
  585
  586
  587
  588
  589
  590
  591
  592
  593
  594
  595
  596
  597
  598
  599
  600
  601
  602
  603
  604
  605
  606
  607
  608
  609
  610
  611
  612
  613
  614
  615
  616
  617
  618
  619
  620
  621
  622
  623
  624
  625
  626
  627
  628
  629
  630
  631
  632
  633
  634
  635
  636
  637
  638
  639
  9775
  9776
  9777
  9778
  9779
  9780
  9958
  9959
  9960
  9961
  9962
  9963
  11522
  11523
  11524
  11525
  11526
  11527
  12380
  12381
  12382
  12383
  12384
  12385
  12641
  12642
  12643
  12644
  12645
  12646
  12647
  12648
  12649
  12650
  12651
  12652
  12695
  12696
  12697
  12698
  12699
  12700
  12802
  12803
  12804
  12805
  12806
  12807
  13145
  13146
  13147
  13148
  13149
  13150
  15441
  15442
  15443
  15444
  15445
  15452
  15453
  15454
  15455
  15456
]
View formatted query    View runnable query    Explain query    View query backtrace
6 3.76 ms 
SELECT a0_.id AS id_0, a0_.value AS value_1, a0_.value_float AS value_float_2, a0_.attribute_id AS attribute_id_3 FROM attribute_value a0_ INNER JOIN attribute a1_ ON a0_.attribute_id = a1_.id INNER JOIN product_variant_attribute_value p2_ ON a0_.id = p2_.attribute_value_id INNER JOIN product_variant p3_ ON p2_.variant_id = p3_.id INNER JOIN product p4_ ON p3_.product_id = p4_.id WHERE p4_.id = ? AND p4_.visible = true AND p3_.visible = true AND a1_.id = ? GROUP BY a0_.id, a0_.value, a0_.value_float, a0_.attribute_id ORDER BY a0_.value ASC
Parameters: 
[
  11
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.73 ms 
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters: 
[
  11
]
View formatted query    View runnable query    Explain query    View query backtrace
8 3.38 ms 
SELECT a0_.id AS id_0, a0_.value AS value_1, a0_.value_float AS value_float_2, a0_.attribute_id AS attribute_id_3 FROM attribute_value a0_ INNER JOIN attribute a1_ ON a0_.attribute_id = a1_.id INNER JOIN product_variant_attribute_value p2_ ON a0_.id = p2_.attribute_value_id INNER JOIN product_variant p3_ ON p2_.variant_id = p3_.id INNER JOIN product p4_ ON p3_.product_id = p4_.id WHERE p4_.id = ? AND p4_.visible = true AND p3_.visible = true AND a1_.id = ? AND p3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.value ASC
Parameters: 
[
  11
  10
  525
  526
  527
  528
  529
  530
  531
  532
  533
  534
  535
  536
  537
  538
  539
  540
  541
  542
  543
  544
  545
  546
  547
  548
  549
  550
  551
  552
  553
  554
  555
  556
  557
  558
  559
  560
  561
  562
  563
  564
  565
  566
  567
  568
  569
  570
  571
  572
  573
  574
  575
  576
  577
  578
  579
  580
  581
  582
  583
  584
  585
  586
  587
  588
  589
  590
  591
  592
  593
  594
  595
  596
  597
  598
  599
  600
  601
  602
  603
  604
  605
  606
  607
  608
  609
  610
  611
  612
  613
  614
  615
  616
  617
  618
  619
  620
  621
  622
  623
  624
  625
  626
  627
  628
  629
  630
  631
  632
  633
  634
  635
  636
  637
  638
  639
  9775
  9776
  9777
  9778
  9779
  9780
  9958
  9959
  9960
  9961
  9962
  9963
  11522
  11523
  11524
  11525
  11526
  11527
  12380
  12381
  12382
  12383
  12384
  12385
  12641
  12642
  12643
  12644
  12645
  12646
  12647
  12648
  12649
  12650
  12651
  12652
  12695
  12696
  12697
  12698
  12699
  12700
  12802
  12803
  12804
  12805
  12806
  12807
  13145
  13146
  13147
  13148
  13149
  13150
  15441
  15442
  15443
  15444
  15445
  15452
  15453
  15454
  15455
  15456
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.72 ms 
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters: 
[
  11
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.58 ms 
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters: 
[
  11
]
View formatted query    View runnable query    Explain query    View query backtrace
11 12.12 ms 
SELECT i0_.id AS id_0, i0_.url AS url_1, i0_.path AS path_2, i0_.filename AS filename_3, i0_.hash AS hash_4 FROM image i0_ INNER JOIN product_variant_image p1_ ON i0_.id = p1_.image_id INNER JOIN product_variant p2_ ON p1_.variant_id = p2_.id INNER JOIN product p3_ ON p2_.product_id = p3_.id WHERE p3_.id = ? AND p3_.visible = true AND p2_.visible = true AND p2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY i0_.id, i0_.url, i0_.path, i0_.filename, i0_.hash ORDER BY i0_.path ASC
Parameters: 
[
  11
  525
  526
  527
  528
  529
  530
  531
  532
  533
  534
  535
  536
  537
  538
  539
  540
  541
  542
  543
  544
  545
  546
  547
  548
  549
  550
  551
  552
  553
  554
  555
  556
  557
  558
  559
  560
  561
  562
  563
  564
  565
  566
  567
  568
  569
  570
  571
  572
  573
  574
  575
  576
  577
  578
  579
  580
  581
  582
  583
  584
  585
  586
  587
  588
  589
  590
  591
  592
  593
  594
  595
  596
  597
  598
  599
  600
  601
  602
  603
  604
  605
  606
  607
  608
  609
  610
  611
  612
  613
  614
  615
  616
  617
  618
  619
  620
  621
  622
  623
  624
  625
  626
  627
  628
  629
  630
  631
  632
  633
  634
  635
  636
  637
  638
  639
  9775
  9776
  9777
  9778
  9779
  9780
  9958
  9959
  9960
  9961
  9962
  9963
  11522
  11523
  11524
  11525
  11526
  11527
  12380
  12381
  12382
  12383
  12384
  12385
  12641
  12642
  12643
  12644
  12645
  12646
  12647
  12648
  12649
  12650
  12651
  12652
  12695
  12696
  12697
  12698
  12699
  12700
  12802
  12803
  12804
  12805
  12806
  12807
  13145
  13146
  13147
  13148
  13149
  13150
  15441
  15442
  15443
  15444
  15445
  15452
  15453
  15454
  15455
  15456
]
View formatted query    View runnable query    Explain query    View query backtrace
12 2.67 ms 
SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.name AS name_2, a0_.visible AS visible_3, a0_.position AS position_4, a0_.depth AS depth_5, a0_.sort_path AS sort_path_6, a1_.id AS id_7, a1_.value AS value_8, a1_.value_float AS value_float_9, a0_.parent_id AS parent_id_10, a1_.attribute_id AS attribute_id_11 FROM attribute a0_ INNER JOIN attribute_value a1_ ON a0_.id = a1_.attribute_id INNER JOIN product_attribute_value p2_ ON a1_.id = p2_.attribute_value_id INNER JOIN product p3_ ON p2_.product_id = p3_.id WHERE p3_.id = ? AND p3_.visible = true AND a0_.visible = true GROUP BY a0_.id, a0_.code, a0_.name, a0_.visible, a0_.position, a0_.depth, a0_.sort_path, a0_.parent_id, a1_.id, a1_.value, a1_.value_float, a1_.attribute_id ORDER BY a0_.sort_path ASC
Parameters: 
[
  11
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.74 ms 
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters: 
[
  11
]
View formatted query    View runnable query    Explain query    View query backtrace
14 2.31 ms 
SELECT MIN(p0_.price) AS sclr_0, MAX(p0_.price) AS sclr_1 FROM product_variant p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id WHERE p1_.id = ? AND p1_.visible = true AND p0_.visible = true AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  11
  525
  526
  527
  528
  529
  530
  531
  532
  533
  534
  535
  536
  537
  538
  539
  540
  541
  542
  543
  544
  545
  546
  547
  548
  549
  550
  551
  552
  553
  554
  555
  556
  557
  558
  559
  560
  561
  562
  563
  564
  565
  566
  567
  568
  569
  570
  571
  572
  573
  574
  575
  576
  577
  578
  579
  580
  581
  582
  583
  584
  585
  586
  587
  588
  589
  590
  591
  592
  593
  594
  595
  596
  597
  598
  599
  600
  601
  602
  603
  604
  605
  606
  607
  608
  609
  610
  611
  612
  613
  614
  615
  616
  617
  618
  619
  620
  621
  622
  623
  624
  625
  626
  627
  628
  629
  630
  631
  632
  633
  634
  635
  636
  637
  638
  639
  9775
  9776
  9777
  9778
  9779
  9780
  9958
  9959
  9960
  9961
  9962
  9963
  11522
  11523
  11524
  11525
  11526
  11527
  12380
  12381
  12382
  12383
  12384
  12385
  12641
  12642
  12643
  12644
  12645
  12646
  12647
  12648
  12649
  12650
  12651
  12652
  12695
  12696
  12697
  12698
  12699
  12700
  12802
  12803
  12804
  12805
  12806
  12807
  13145
  13146
  13147
  13148
  13149
  13150
  15441
  15442
  15443
  15444
  15445
  15452
  15453
  15454
  15455
  15456
]
View formatted query    View runnable query    Explain query    View query backtrace
15 1.28 ms 
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.visible AS visible_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.position AS position_5, c0_.depth AS depth_6, c0_.sort_path AS sort_path_7, c0_.parent_id AS parent_id_8 FROM category c0_ WHERE c0_.parent_id IS NULL AND c0_.visible = true ORDER BY c0_.sort_path ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.99 ms 
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.attachment_image_id AS attachment_image_id_3 FROM product_attachment_image t0 WHERE t0.product_id = ?
Parameters: 
[
  11
]
View formatted query    View runnable query    Explain query    View query backtrace
17 1.24 ms 
SELECT t0.id AS id_1, t0.url AS url_2, t0.path AS path_3, t0.filename AS filename_4, t0.hash AS hash_5, t0.attachment_id AS attachment_id_6 FROM attachment_image t0 WHERE t0.id = ?
Parameters: 
[
  21
]
View formatted query    View runnable query    Explain query    View query backtrace
18 1.11 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.visible AS visible_4, t0.position AS position_5, t0.depth AS depth_6, t0.sort_path AS sort_path_7, t0.parent_id AS parent_id_8 FROM attachment t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.55 ms 
SELECT t0.id AS id_1, t0.url AS url_2, t0.path AS path_3, t0.filename AS filename_4, t0.hash AS hash_5, t0.attachment_id AS attachment_id_6 FROM attachment_image t0 WHERE t0.id = ?
Parameters: 
[
  22
]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.51 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.visible AS visible_4, t0.position AS position_5, t0.depth AS depth_6, t0.sort_path AS sort_path_7, t0.parent_id AS parent_id_8 FROM attachment t0 WHERE t0.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Image 128
App\Entity\AttributeValue 49
App\Entity\Category 15
App\Entity\Attribute 11
App\Entity\ProductAttachmentImage 2
App\Entity\AttachmentImage 2
App\Entity\Attachment 2
App\Entity\Product 1
App\Entity\Source 1
App\Entity\Manufacturer 1
App\Entity\RemoteCategory 1

Entities Mapping

Class Mapping errors
App\Entity\Product No errors.
App\Entity\Source No errors.
App\Entity\Manufacturer No errors.
App\Entity\RemoteCategory No errors.
App\Entity\ProductAttachmentImage No errors.
App\Entity\ProductVariant No errors.
App\Entity\ProductAttributeValue No errors.
App\Entity\Attribute No errors.
App\Entity\AttributeValue No errors.
App\Entity\ProductVariantAttributeValue No errors.
App\Entity\Image No errors.
App\Entity\ProductVariantImage No errors.
App\Entity\Category No errors.
App\Entity\AttachmentImage No errors.
App\Entity\Attachment No errors.