Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
177.28 ms
(87.29%)
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
  2407
  7748
  32761
  38076
  53698
  118869
  174164
  185435
  188150
  230399
  370928
  382458
  383971
  384251
  385496
  386869
  386925
  388805
  390257
  391812
  396001
  396575
  397086
  397812
  398704
  398757
  402539
  407176
  413770
  416432
  416869
  421783
  423781
  426780
  427813
  428602
  428825
  432485
  432573
  432759
  437564
  441691
  446524
  447224
  447250
  447711
  447938
  448253
  449854
  449862
  453944
  457107
  457917
  458109
  458534
  460306
  461286
  465223
  466224
  466496
  466793
  472074
  473490
  474500
  475607
  477605
  485408
  485981
  487973
  488296
  488931
  489172
  492349
  494066
  495047
  495322
  497846
  508990
  509202
  509521
  509721
  525272
  525306
  527595
  567612
  570296
  572501
  572703
  586973
  588662
  591913
  595131
  595137
  595231
  596818
  597279
  604993
  612445
  615316
  616519
  616526
  619728
  622309
  634992
  635415
  643250
  643835
  700915
  702224
  745968
  757318
  774037
  777937
  778124
  779755
  782852
  797709
  805188
  810622
  827199
]
15.58 ms
(7.67%)
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
  567612
  570296
  572501
  572703
  595137
  616519
  622309
  634992
  588662
  595131
  597279
  604993
  643250
  586973
  591913
  595231
  596818
  616526
  777937
  779755
  782852
  805188
  778124
  757318
  774037
  745968
  615316
  635415
  643835
  702224
  797709
  810622
  370928
  396001
  407176
  428825
  432485
  7748
  391812
  416869
  460306
  474500
  384251
  385496
  230399
  390257
  397086
  398757
  447224
  447938
  457917
  509202
  489172
  509521
  527595
  487973
  508990
  485408
  488296
  495047
  509721
  619728
  612445
  494066
  525272
  525306
  2407
  700915
  827199
  386869
  383971
  118869
  174164
  185435
  382458
  32761
  38076
  53698
  188150
  388805
  386925
  396575
  397812
  398704
  402539
  421783
  423781
  428602
  432573
  427813
  413770
  416432
  432759
  441691
  437564
  426780
  447711
  449862
  457107
  458109
  465223
  475607
  492349
  449854
  466496
  466793
  477605
  488931
  446524
  447250
  448253
  453944
  458534
  461286
  466224
  472074
  473490
  485981
  495322
  497846
]
2.97 ms
(1.46%)
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
  2407
  7748
  32761
  38076
  53698
  118869
  174164
  185435
  188150
  230399
  370928
  382458
  383971
  384251
  385496
  386869
  386925
  388805
  390257
  391812
  396001
  396575
  397086
  397812
  398704
  398757
  402539
  407176
  413770
  416432
  416869
  421783
  423781
  426780
  427813
  428602
  428825
  432485
  432573
  432759
  437564
  441691
  446524
  447224
  447250
  447711
  447938
  448253
  449854
  449862
  453944
  457107
  457917
  458109
  458534
  460306
  461286
  465223
  466224
  466496
  466793
  472074
  473490
  474500
  475607
  477605
  485408
  485981
  487973
  488296
  488931
  489172
  492349
  494066
  495047
  495322
  497846
  508990
  509202
  509521
  509721
  525272
  525306
  527595
  567612
  570296
  572501
  572703
  586973
  588662
  591913
  595131
  595137
  595231
  596818
  597279
  604993
  612445
  615316
  616519
  616526
  619728
  622309
  634992
  635415
  643250
  643835
  700915
  702224
  745968
  757318
  774037
  777937
  778124
  779755
  782852
  797709
  805188
  810622
  827199
]
2.35 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "скачать сверху"
]
1.71 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "скача наездниц поз"
]
1.64 ms
(0.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.77%)
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.