Query Metrics

7 Database Queries
7 Different statements
575.32 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
549.54 ms
(95.52%)
1
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  150405
  384144
  412043
  414350
  428238
  429801
  445367
  453406
  458764
  461890
  468120
  473429
  476082
  476783
  482712
  485149
  488475
  497517
  501643
  527780
  532790
  532852
  532855
  533870
  536628
  545046
  547467
  548517
  549137
  549996
  551319
  551442
  552664
  552791
  553274
  555104
  557376
  559161
  560164
  560216
  560459
  561140
  562844
  564387
  564706
  565039
  566553
  567097
  567321
  567337
  568457
  568478
  569258
  569457
  569550
  569556
  569722
  569736
  569770
  570390
  570854
  570857
  571216
  573743
  574196
  579685
  582024
  583041
  585960
  586561
  590218
  590246
  590952
  591109
  591383
  592444
  593270
  593743
  593877
  594956
  596242
  598113
  599664
  599921
  600027
  600273
  600626
  603210
  603674
  603723
  603927
  604766
  604800
  605470
  607080
  607565
  617416
  625888
  631457
  651128
  660023
  660399
  660410
  670495
  714475
  726081
  727580
  727622
  728060
  729281
  752878
  773554
  773895
  776503
  782018
  784961
  785431
  800005
  803610
  807170
]
16.34 ms
(2.84%)
1
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  800005
  428238
  533870
  567321
  660399
  603210
  592444
  468120
  532855
  384144
  603674
  776503
  773554
  536628
  414350
  532790
  547467
  660410
  553274
  569258
  599921
  585960
  593743
  617416
  461890
  560459
  566553
  570857
  569770
  570854
  557376
  600027
  600273
  590952
  586561
  591383
  596242
  773895
  150405
  453406
  568478
  573743
  569736
  651128
  670495
  570390
  631457
  607565
  600626
  604800
  807170
  729281
  727580
  728060
  752878
  473429
  497517
  555104
  476783
  785431
  488475
  560164
  660023
  545046
  551319
  604766
  726081
  803610
  458764
  501643
  532852
  568457
  567337
  583041
  782018
  784961
  429801
  445367
  527780
  476082
  714475
  605470
  485149
  603723
  412043
  564387
  564706
  571216
  569457
  591109
  593877
  552791
  560216
  569556
  551442
  599664
  482712
  549137
  598113
  603927
  625888
  548517
  565039
  569550
  569722
  574196
  579685
  549996
  562844
  567097
  590246
  593270
  607080
  594956
  590218
  727622
  559161
  552664
  561140
  582024
]
2.80 ms
(0.49%)
1
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  150405
  384144
  412043
  414350
  428238
  429801
  445367
  453406
  458764
  461890
  468120
  473429
  476082
  476783
  482712
  485149
  488475
  497517
  501643
  527780
  532790
  532852
  532855
  533870
  536628
  545046
  547467
  548517
  549137
  549996
  551319
  551442
  552664
  552791
  553274
  555104
  557376
  559161
  560164
  560216
  560459
  561140
  562844
  564387
  564706
  565039
  566553
  567097
  567321
  567337
  568457
  568478
  569258
  569457
  569550
  569556
  569722
  569736
  569770
  570390
  570854
  570857
  571216
  573743
  574196
  579685
  582024
  583041
  585960
  586561
  590218
  590246
  590952
  591109
  591383
  592444
  593270
  593743
  593877
  594956
  596242
  598113
  599664
  599921
  600027
  600273
  600626
  603210
  603674
  603723
  603927
  604766
  604800
  605470
  607080
  607565
  617416
  625888
  631457
  651128
  660023
  660399
  660410
  670495
  714475
  726081
  727580
  727622
  728060
  729281
  752878
  773554
  773895
  776503
  782018
  784961
  785431
  800005
  803610
  807170
]
1.91 ms
(0.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big butt mother"
]
1.67 ms
(0.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие butt мам женщин"
]
1.57 ms
(0.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие butt мам женщин"
]

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

No loaded entities.