Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.20 ms
(81.23%)
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
  4298
  410602
  416092
  427383
  428068
  428933
  432361
  433186
  444109
  451257
  455917
  456807
  457991
  462564
  463172
  463262
  465381
  469494
  469656
  470091
  471435
  473891
  474806
  476282
  476344
  477722
  477938
  477955
  478933
  479211
  480064
  480817
  480959
  481664
  482296
  482798
  484854
  484973
  486013
  488594
  488993
  489573
  489627
  490086
  492011
  492334
  494702
  495159
  498435
  498740
  502002
  502910
  504602
  508116
  510043
  511306
  511520
  516653
  517106
  517713
  520455
  520746
  522168
  522386
  523539
  525251
  526773
  527791
  530528
  543255
  544468
  546125
  550442
  552635
  554259
  560206
  561682
  563427
  563540
  563659
  564429
  565958
  566375
  566833
  567342
  568122
  569540
  569690
  569885
  569913
  570655
  571227
  571793
  573640
  574294
  575803
  576274
  576991
  577320
  580670
  581172
  582114
  585668
  589129
  592054
  595506
  595755
  595757
  597830
  601407
  603102
  605855
  608497
  620203
  621397
  624838
  627700
  628351
  636322
  679097
]
20.35 ms
(12.05%)
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
  498740
  526773
  546125
  476282
  492011
  581172
  463172
  477955
  465381
  522168
  480064
  563540
  636322
  620203
  550442
  627700
  563659
  4298
  416092
  456807
  477938
  479211
  488594
  569913
  595506
  474806
  455917
  502002
  525251
  527791
  478933
  469494
  570655
  482798
  511306
  522386
  575803
  574294
  554259
  624838
  410602
  566833
  427383
  504602
  564429
  484854
  490086
  569885
  595755
  432361
  567342
  565958
  595757
  597830
  480959
  462564
  520455
  492334
  433186
  457991
  482296
  484973
  517713
  543255
  544468
  568122
  569540
  569690
  571793
  552635
  560206
  576274
  576991
  577320
  608497
  589129
  628351
  477722
  476344
  508116
  489627
  517106
  489573
  498435
  523539
  494702
  451257
  603102
  428933
  481664
  480817
  473891
  502910
  516653
  510043
  530528
  471435
  580670
  582114
  561682
  679097
  563427
  571227
  605855
  463262
  470091
  469656
  511520
  621397
  585668
  566375
  520746
  573640
  444109
  428068
  495159
  486013
  488993
  592054
  601407
]
3.01 ms
(1.78%)
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
  4298
  410602
  416092
  427383
  428068
  428933
  432361
  433186
  444109
  451257
  455917
  456807
  457991
  462564
  463172
  463262
  465381
  469494
  469656
  470091
  471435
  473891
  474806
  476282
  476344
  477722
  477938
  477955
  478933
  479211
  480064
  480817
  480959
  481664
  482296
  482798
  484854
  484973
  486013
  488594
  488993
  489573
  489627
  490086
  492011
  492334
  494702
  495159
  498435
  498740
  502002
  502910
  504602
  508116
  510043
  511306
  511520
  516653
  517106
  517713
  520455
  520746
  522168
  522386
  523539
  525251
  526773
  527791
  530528
  543255
  544468
  546125
  550442
  552635
  554259
  560206
  561682
  563427
  563540
  563659
  564429
  565958
  566375
  566833
  567342
  568122
  569540
  569690
  569885
  569913
  570655
  571227
  571793
  573640
  574294
  575803
  576274
  576991
  577320
  580670
  581172
  582114
  585668
  589129
  592054
  595506
  595755
  595757
  597830
  601407
  603102
  605855
  608497
  620203
  621397
  624838
  627700
  628351
  636322
  679097
]
2.63 ms
(1.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "куни со спины"
]
2.12 ms
(1.25%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "куннилингус оральн секс спин"
]
1.93 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "куннилингус оральн секс спин"
]
1.67 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.