Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
173.22 ms
(86.28%)
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
  395144
  421236
  434097
  437663
  438219
  439765
  444612
  446815
  452146
  453441
  454228
  462949
  465498
  467066
  467837
  469477
  470568
  472078
  474113
  474433
  474461
  474538
  475240
  475280
  476706
  480296
  480707
  481965
  482539
  482620
  483350
  484379
  487260
  490474
  490783
  493896
  496057
  496311
  496518
  496874
  498594
  502249
  503859
  508515
  509430
  510456
  512955
  513828
  514575
  517687
  519316
  519825
  520340
  521203
  521350
  524327
  528452
  532545
  533320
  533388
  533998
  541162
  541831
  541887
  541897
  542885
  545857
  547543
  548169
  549311
  549391
  549968
  554826
  555317
  556786
  557475
  557499
  562147
  564816
  565571
  566075
  566704
  568383
  569196
  570797
  572551
  572603
  576519
  579622
  587998
  590730
  592477
  593185
  593596
  601438
  614829
  622385
  625783
  629571
  630890
  635839
  674206
  697459
  715509
  716167
  716765
  724126
  724740
  731124
  732163
  759132
  759691
  776940
  797142
  801292
  805139
  805149
  813249
  814849
  816958
]
16.32 ms
(8.13%)
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
  487260
  814849
  480296
  533998
  697459
  801292
  776940
  438219
  474433
  474113
  484379
  476706
  446815
  469477
  532545
  545857
  579622
  542885
  674206
  601438
  724740
  732163
  715509
  593596
  395144
  496518
  508515
  513828
  816958
  475240
  481965
  521203
  533320
  474538
  541897
  555317
  549391
  568383
  549311
  805149
  813249
  434097
  467837
  490474
  462949
  444612
  453441
  483350
  512955
  519316
  519825
  514575
  541887
  716765
  590730
  759691
  454228
  509430
  496057
  490783
  587998
  533388
  521350
  496311
  541162
  547543
  572603
  569196
  557475
  566704
  548169
  570797
  635839
  630890
  797142
  731124
  759132
  724126
  614829
  472078
  554826
  467066
  482620
  474461
  482539
  805139
  593185
  480707
  528452
  502249
  541831
  421236
  452146
  470568
  465498
  503859
  520340
  524327
  565571
  566075
  549968
  564816
  716167
  556786
  572551
  576519
  629571
  622385
  592477
  510456
  498594
  437663
  517687
  557499
  562147
  625783
  493896
  439765
  496874
  475280
]
2.85 ms
(1.42%)
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
  395144
  421236
  434097
  437663
  438219
  439765
  444612
  446815
  452146
  453441
  454228
  462949
  465498
  467066
  467837
  469477
  470568
  472078
  474113
  474433
  474461
  474538
  475240
  475280
  476706
  480296
  480707
  481965
  482539
  482620
  483350
  484379
  487260
  490474
  490783
  493896
  496057
  496311
  496518
  496874
  498594
  502249
  503859
  508515
  509430
  510456
  512955
  513828
  514575
  517687
  519316
  519825
  520340
  521203
  521350
  524327
  528452
  532545
  533320
  533388
  533998
  541162
  541831
  541887
  541897
  542885
  545857
  547543
  548169
  549311
  549391
  549968
  554826
  555317
  556786
  557475
  557499
  562147
  564816
  565571
  566075
  566704
  568383
  569196
  570797
  572551
  572603
  576519
  579622
  587998
  590730
  592477
  593185
  593596
  601438
  614829
  622385
  625783
  629571
  630890
  635839
  674206
  697459
  715509
  716167
  716765
  724126
  724740
  731124
  732163
  759132
  759691
  776940
  797142
  801292
  805139
  805149
  813249
  814849
  816958
]
2.42 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "нарезка--в--туалете--женщин--"
]
2.21 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.15 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "подборк туалет женщин"
]
1.60 ms
(0.80%)
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.