Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
169.27 ms
(87.87%)
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
  387858
  390573
  400714
  412910
  419096
  421652
  422359
  425352
  427809
  428113
  432711
  433968
  438487
  440788
  441031
  442775
  450175
  455373
  456015
  458201
  465277
  467728
  477235
  489657
  490797
  490825
  491010
  499757
  507909
  511315
  514032
  524812
  525063
  527596
  527973
  529331
  533901
  537161
  538497
  538624
  540073
  547052
  549686
  549708
  562975
  566900
  567330
  569497
  578762
  579823
  592582
  599010
  602515
  605674
  610345
  618735
  620208
  622163
  622650
  625753
  627319
  630092
  630664
  631632
  633812
  634789
  635973
  637247
  640807
  653209
  656495
  666188
  672777
  675188
  694883
  697010
  702881
  706785
  707526
  709756
  712318
  714779
  715556
  719851
  720417
  720965
  727032
  727665
  728229
  733144
  733236
  735910
  738532
  743782
  744994
  749150
  756321
  758210
  761047
  761293
  764909
  765102
  766523
  772035
  777526
  783992
  784306
  785153
  793627
  794247
  794800
  795807
  797128
  797133
  798823
  803208
  805772
  806449
  808834
  813029
]
14.15 ms
(7.35%)
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
  579823
  694883
  709756
  707526
  712318
  653209
  706785
  569497
  622163
  610345
  640807
  777526
  808834
  766523
  772035
  798823
  765102
  387858
  438487
  456015
  490797
  490825
  491010
  511315
  527596
  533901
  537161
  538624
  540073
  529331
  549686
  549708
  547052
  656495
  666188
  702881
  714779
  715556
  719851
  562975
  567330
  578762
  605674
  637247
  599010
  602515
  620208
  633812
  631632
  592582
  627319
  794800
  795807
  803208
  793627
  805772
  813029
  761293
  784306
  727665
  728229
  733144
  738532
  756321
  735910
  727032
  758210
  761047
  618735
  622650
  625753
  630664
  634789
  635973
  783992
  797133
  421652
  422359
  442775
  419096
  507909
  525063
  527973
  440788
  432711
  428113
  450175
  538497
  514032
  489657
  566900
  720417
  720965
  672777
  630092
  794247
  797128
  806449
  733236
  785153
  764909
  743782
  744994
  749150
  697010
  427809
  441031
  455373
  458201
  477235
  390573
  467728
  499757
  465277
  675188
  412910
  524812
  400714
  425352
  433968
]
2.60 ms
(1.35%)
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
  387858
  390573
  400714
  412910
  419096
  421652
  422359
  425352
  427809
  428113
  432711
  433968
  438487
  440788
  441031
  442775
  450175
  455373
  456015
  458201
  465277
  467728
  477235
  489657
  490797
  490825
  491010
  499757
  507909
  511315
  514032
  524812
  525063
  527596
  527973
  529331
  533901
  537161
  538497
  538624
  540073
  547052
  549686
  549708
  562975
  566900
  567330
  569497
  578762
  579823
  592582
  599010
  602515
  605674
  610345
  618735
  620208
  622163
  622650
  625753
  627319
  630092
  630664
  631632
  633812
  634789
  635973
  637247
  640807
  653209
  656495
  666188
  672777
  675188
  694883
  697010
  702881
  706785
  707526
  709756
  712318
  714779
  715556
  719851
  720417
  720965
  727032
  727665
  728229
  733144
  733236
  735910
  738532
  743782
  744994
  749150
  756321
  758210
  761047
  761293
  764909
  765102
  766523
  772035
  777526
  783992
  784306
  785153
  793627
  794247
  794800
  795807
  797128
  797133
  798823
  803208
  805772
  806449
  808834
  813029
]
2.00 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "natural tits creampie"
]
1.76 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "натуральная натуральные сиськ без силикон creampie"
]
1.15 ms
(0.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "натуральная натуральные сиськ без силикон creampie"
]

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.