Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.72 ms
(83.36%)
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
  233292
  392054
  400179
  401196
  413089
  419093
  428143
  428810
  429492
  432663
  437797
  439627
  444379
  446901
  449089
  449719
  450649
  454540
  454989
  455281
  457856
  459143
  460746
  464561
  464663
  469486
  470762
  471849
  476332
  477327
  477392
  481805
  482251
  485271
  486536
  490413
  491061
  493171
  500725
  509392
  518147
  519046
  519137
  521476
  524314
  526008
  529496
  530329
  531528
  534190
  536353
  542908
  549822
  554579
  555077
  557049
  560989
  561409
  563924
  565679
  568368
  572210
  585728
  588942
  597047
  603458
  609584
  610058
  614089
  623392
  672251
  682269
  683460
  687663
  703467
  705256
  710595
  723981
  725197
  726470
  726598
  726845
  730524
  731916
  737618
  742497
  742839
  743809
  748689
  758443
  759105
  759740
  765023
  771139
  786167
  788282
  790803
  793526
  795033
  795041
  800234
  802185
  802274
  807805
  808012
  810062
  810069
  810819
  812634
  814895
  817737
  819916
  819919
  820126
  824125
  824229
  825101
  826267
  827264
  827577
]
16.45 ms
(10.49%)
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
  742497
  428810
  817737
  603458
  808012
  429492
  444379
  469486
  623392
  726598
  743809
  531528
  824125
  687663
  771139
  703467
  449719
  683460
  470762
  554579
  814895
  530329
  705256
  588942
  723981
  800234
  730524
  731916
  542908
  682269
  536353
  509392
  400179
  526008
  500725
  481805
  568368
  795033
  555077
  810069
  401196
  439627
  413089
  464663
  524314
  563924
  710595
  560989
  812634
  802185
  742839
  790803
  765023
  726470
  725197
  482251
  437797
  454540
  521476
  428143
  446901
  486536
  419093
  477392
  449089
  672251
  609584
  471849
  786167
  565679
  392054
  826267
  795041
  459143
  519137
  490413
  819919
  561409
  597047
  807805
  726845
  759740
  610058
  810062
  737618
  477327
  519046
  457856
  534190
  557049
  529496
  585728
  758443
  455281
  788282
  233292
  450649
  493171
  432663
  820126
  518147
  819916
  827264
  827577
  825101
  572210
  793526
  810819
  759105
  454989
  802274
  824229
  476332
  491061
  464561
  549822
  485271
  460746
  614089
  748689
]
2.83 ms
(1.80%)
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
  233292
  392054
  400179
  401196
  413089
  419093
  428143
  428810
  429492
  432663
  437797
  439627
  444379
  446901
  449089
  449719
  450649
  454540
  454989
  455281
  457856
  459143
  460746
  464561
  464663
  469486
  470762
  471849
  476332
  477327
  477392
  481805
  482251
  485271
  486536
  490413
  491061
  493171
  500725
  509392
  518147
  519046
  519137
  521476
  524314
  526008
  529496
  530329
  531528
  534190
  536353
  542908
  549822
  554579
  555077
  557049
  560989
  561409
  563924
  565679
  568368
  572210
  585728
  588942
  597047
  603458
  609584
  610058
  614089
  623392
  672251
  682269
  683460
  687663
  703467
  705256
  710595
  723981
  725197
  726470
  726598
  726845
  730524
  731916
  737618
  742497
  742839
  743809
  748689
  758443
  759105
  759740
  765023
  771139
  786167
  788282
  790803
  793526
  795033
  795041
  800234
  802185
  802274
  807805
  808012
  810062
  810069
  810819
  812634
  814895
  817737
  819916
  819919
  820126
  824125
  824229
  825101
  826267
  827264
  827577
]
2.33 ms
(1.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ÐéÐÇð░Ðàð░ðÁÐé Ðüð┐ÐÅÐëÐâÐÄ ð╝ð░ð╝ð░ÐêÐ%ÔǪ"
]
1.71 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс спящ мам женщин"
]
1.32 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.