Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
201.59 ms
(89.54%)
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
  400483
  416880
  417102
  418138
  422733
  423697
  435746
  443031
  443311
  446666
  448851
  449450
  450326
  450787
  451108
  451333
  452326
  453061
  454402
  455495
  455620
  455979
  456954
  458326
  458787
  460093
  463313
  463411
  463966
  470067
  471326
  471328
  472683
  475624
  477858
  478060
  485290
  485785
  487975
  492312
  494325
  499529
  501830
  504320
  504848
  506118
  509137
  511216
  511953
  514655
  516510
  516613
  517676
  520823
  523666
  523937
  526415
  530303
  543351
  551612
  555799
  558261
  558606
  560002
  560613
  561344
  561492
  572250
  572268
  573267
  573453
  573789
  576179
  578705
  579128
  579279
  579390
  579631
  585276
  585703
  585752
  589793
  590917
  591108
  592989
  598840
  599734
  600653
  600859
  601170
  604677
  606765
  612387
  614773
  618332
  621745
  622257
  628289
  633934
  635723
  637172
  650276
  650742
  665822
  667810
  671426
  686596
  687929
  689004
  702007
  718455
  719388
  729678
  729826
  730975
  753752
  760610
  775487
  792614
  814753
]
12.95 ms
(5.75%)
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
  579631
  573267
  687929
  667810
  719388
  560613
  572268
  573789
  599734
  621745
  589793
  475624
  471326
  418138
  450326
  471328
  460093
  463966
  511216
  514655
  523937
  485785
  523666
  417102
  455495
  450787
  455620
  463313
  478060
  511953
  509137
  517676
  516613
  530303
  543351
  572250
  665822
  598840
  600859
  592989
  633934
  753752
  400483
  458326
  451333
  504320
  579279
  499529
  449450
  516510
  573453
  551612
  760610
  422733
  504848
  477858
  558606
  560002
  637172
  792614
  448851
  470067
  492312
  814753
  456954
  458787
  506118
  561492
  650276
  718455
  686596
  702007
  671426
  578705
  579128
  585276
  604677
  618332
  585752
  591108
  606765
  612387
  635723
  590917
  600653
  622257
  729678
  730975
  729826
  614773
  628289
  775487
  446666
  453061
  501830
  526415
  423697
  452326
  463411
  451108
  487975
  561344
  555799
  576179
  650742
  689004
  585703
  601170
  443311
  435746
  443031
  520823
  416880
  455979
  454402
  485290
  494325
  472683
  558261
  579390
]
2.83 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "watching girl"
]
2.48 ms
(1.10%)
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
  400483
  416880
  417102
  418138
  422733
  423697
  435746
  443031
  443311
  446666
  448851
  449450
  450326
  450787
  451108
  451333
  452326
  453061
  454402
  455495
  455620
  455979
  456954
  458326
  458787
  460093
  463313
  463411
  463966
  470067
  471326
  471328
  472683
  475624
  477858
  478060
  485290
  485785
  487975
  492312
  494325
  499529
  501830
  504320
  504848
  506118
  509137
  511216
  511953
  514655
  516510
  516613
  517676
  520823
  523666
  523937
  526415
  530303
  543351
  551612
  555799
  558261
  558606
  560002
  560613
  561344
  561492
  572250
  572268
  573267
  573453
  573789
  576179
  578705
  579128
  579279
  579390
  579631
  585276
  585703
  585752
  589793
  590917
  591108
  592989
  598840
  599734
  600653
  600859
  601170
  604677
  606765
  612387
  614773
  618332
  621745
  622257
  628289
  633934
  635723
  637172
  650276
  650742
  665822
  667810
  671426
  686596
  687929
  689004
  702007
  718455
  719388
  729678
  729826
  730975
  753752
  760610
  775487
  792614
  814753
]
2.04 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(0.75%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "watching девушк"
]
1.55 ms
(0.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "watching девушк"
]

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.