Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.57 ms
(82.73%)
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
  396877
  409585
  411370
  417384
  418124
  419777
  421010
  426009
  430835
  431126
  434561
  438058
  442910
  444158
  444227
  445367
  445630
  451430
  452692
  455502
  457889
  460750
  466025
  466085
  466130
  466262
  468929
  469471
  470169
  470772
  470783
  472169
  472855
  472956
  475410
  475865
  477580
  482228
  482618
  482643
  486366
  490274
  490901
  490946
  491227
  491405
  492515
  493493
  494786
  508595
  512257
  512739
  513033
  515420
  515865
  515922
  516550
  518280
  518566
  519945
  519948
  520237
  520428
  520473
  522827
  522847
  524952
  524990
  525795
  526029
  527121
  528261
  529565
  546930
  555582
  558009
  558645
  561853
  563477
  564949
  565936
  566521
  567153
  567429
  568083
  571267
  572042
  575790
  576100
  576379
  577120
  577364
  577365
  578467
  580318
  580321
  580646
  583969
  588631
  592444
  594874
  596809
  598601
  601027
  601253
  602933
  606317
  615740
  615929
  618476
  623266
  644038
  649080
  663864
  663888
  663952
  675515
  681686
  689755
  807492
]
16.40 ms
(11.07%)
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
  601253
  491227
  431126
  689755
  615740
  411370
  519945
  519948
  594874
  592444
  430835
  580646
  527121
  421010
  451430
  522847
  563477
  577120
  580321
  580318
  596809
  457889
  486366
  472956
  469471
  409585
  491405
  526029
  564949
  572042
  558009
  663952
  588631
  434561
  444227
  466025
  466085
  512257
  515865
  492515
  490946
  522827
  396877
  598601
  561853
  524952
  576379
  438058
  482228
  529565
  515922
  524990
  568083
  663864
  644038
  470772
  470169
  472855
  419777
  490274
  518280
  649080
  577365
  807492
  444158
  577364
  475410
  663888
  578467
  445367
  615929
  452692
  482618
  508595
  494786
  528261
  575790
  442910
  520428
  418124
  472169
  681686
  455502
  518566
  468929
  513033
  520473
  477580
  466262
  567153
  571267
  601027
  520237
  618476
  583969
  675515
  417384
  493493
  512739
  576100
  602933
  567429
  470783
  515420
  460750
  525795
  490901
  445630
  623266
  426009
  482643
  546930
  555582
  565936
  566521
  558645
  606317
  466130
  475865
  516550
]
2.64 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
  396877
  409585
  411370
  417384
  418124
  419777
  421010
  426009
  430835
  431126
  434561
  438058
  442910
  444158
  444227
  445367
  445630
  451430
  452692
  455502
  457889
  460750
  466025
  466085
  466130
  466262
  468929
  469471
  470169
  470772
  470783
  472169
  472855
  472956
  475410
  475865
  477580
  482228
  482618
  482643
  486366
  490274
  490901
  490946
  491227
  491405
  492515
  493493
  494786
  508595
  512257
  512739
  513033
  515420
  515865
  515922
  516550
  518280
  518566
  519945
  519948
  520237
  520428
  520473
  522827
  522847
  524952
  524990
  525795
  526029
  527121
  528261
  529565
  546930
  555582
  558009
  558645
  561853
  563477
  564949
  565936
  566521
  567153
  567429
  568083
  571267
  572042
  575790
  576100
  576379
  577120
  577364
  577365
  578467
  580318
  580321
  580646
  583969
  588631
  592444
  594874
  596809
  598601
  601027
  601253
  602933
  606317
  615740
  615929
  618476
  623266
  644038
  649080
  663864
  663888
  663952
  675515
  681686
  689755
  807492
]
2.09 ms
(1.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "куни под стол"
]
1.71 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "куннилингус оральн секс стол"
]
1.25 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.