Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.50 ms
(84.27%)
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
  17093
  154694
  233029
  358566
  386648
  387856
  389462
  390734
  391288
  391492
  391519
  391954
  398553
  398957
  400989
  401009
  401199
  402131
  403264
  411324
  411368
  411381
  411576
  414125
  421573
  422353
  424259
  425139
  426711
  426898
  428817
  433946
  436419
  437059
  443703
  443847
  444147
  444658
  448708
  452979
  454222
  454273
  455228
  459159
  460580
  465243
  465333
  465907
  466240
  466309
  467452
  467738
  467846
  468113
  468304
  468307
  468831
  470581
  470607
  470639
  471592
  471883
  474493
  474659
  475556
  476930
  479979
  480870
  481777
  484241
  484390
  484684
  489388
  490888
  491904
  491935
  494444
  495093
  497249
  497565
  498962
  500184
  502012
  502523
  503003
  510214
  510665
  511554
  513717
  516718
  517579
  518241
  520110
  520574
  520811
  522011
  526827
  534678
  537267
  556331
  560325
  564082
  565320
  570103
  573729
  597947
  599234
  604674
  619529
  620265
  625553
  627095
  722825
  741710
  745777
  746157
  757803
  778270
  807595
  809720
]
15.90 ms
(10.19%)
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
  466309
  722825
  411368
  17093
  391492
  444147
  522011
  465333
  443703
  468831
  454273
  500184
  560325
  391954
  465243
  425139
  426898
  479979
  411381
  454222
  468307
  467846
  510665
  401199
  422353
  484684
  757803
  778270
  436419
  510214
  503003
  391519
  481777
  494444
  498962
  511554
  516718
  411576
  502523
  534678
  556331
  625553
  807595
  809720
  480870
  470639
  474659
  537267
  490888
  468304
  627095
  390734
  443847
  620265
  455228
  741710
  233029
  414125
  497565
  471883
  476930
  565320
  599234
  437059
  403264
  484241
  520811
  421573
  491904
  402131
  520574
  746157
  745777
  470581
  433946
  474493
  526827
  452979
  389462
  398553
  400989
  448708
  475556
  387856
  471592
  467452
  484390
  513717
  497249
  502012
  570103
  604674
  619529
  459159
  465907
  358566
  467738
  468113
  495093
  491935
  520110
  573729
  391288
  564082
  411324
  398957
  386648
  518241
  466240
  424259
  426711
  460580
  154694
  517579
  401009
  428817
  470607
  444658
  489388
  597947
]
2.08 ms
(1.34%)
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
  17093
  154694
  233029
  358566
  386648
  387856
  389462
  390734
  391288
  391492
  391519
  391954
  398553
  398957
  400989
  401009
  401199
  402131
  403264
  411324
  411368
  411381
  411576
  414125
  421573
  422353
  424259
  425139
  426711
  426898
  428817
  433946
  436419
  437059
  443703
  443847
  444147
  444658
  448708
  452979
  454222
  454273
  455228
  459159
  460580
  465243
  465333
  465907
  466240
  466309
  467452
  467738
  467846
  468113
  468304
  468307
  468831
  470581
  470607
  470639
  471592
  471883
  474493
  474659
  475556
  476930
  479979
  480870
  481777
  484241
  484390
  484684
  489388
  490888
  491904
  491935
  494444
  495093
  497249
  497565
  498962
  500184
  502012
  502523
  503003
  510214
  510665
  511554
  513717
  516718
  517579
  518241
  520110
  520574
  520811
  522011
  526827
  534678
  537267
  556331
  560325
  564082
  565320
  570103
  573729
  597947
  599234
  604674
  619529
  620265
  625553
  627095
  722825
  741710
  745777
  746157
  757803
  778270
  807595
  809720
]
1.73 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian blonde stockings"
]
1.71 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск беловолосая чулк нижн бел"
]
1.65 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(0.95%)
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.