Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.21 ms
(80.30%)
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
  389612
  389973
  400854
  401140
  406217
  412583
  413100
  420311
  421181
  421207
  423320
  423336
  424056
  424443
  424675
  430255
  430303
  432172
  432831
  432886
  442494
  442771
  443274
  443760
  443761
  443763
  443767
  443812
  445182
  446811
  447618
  449180
  454251
  454317
  454322
  454542
  456369
  456883
  460731
  460745
  460750
  462319
  462799
  464322
  464703
  465335
  465355
  466085
  466101
  466118
  466207
  470560
  470772
  471056
  474016
  475121
  476342
  476344
  479040
  480742
  481591
  484377
  484484
  484601
  484914
  485691
  486531
  489461
  490262
  492719
  493093
  494557
  494786
  497337
  503965
  504604
  506050
  506997
  507540
  509481
  510571
  510750
  511691
  512831
  516393
  520890
  521260
  521516
  523040
  523169
  525349
  526077
  526083
  526737
  528071
  528258
  543343
  543812
  564786
  569427
  570521
  571210
  571680
  576643
  586015
  587530
  587817
  590959
  595061
  595931
  596966
  610311
  618803
  640029
  650487
  662896
  669276
  807340
  814431
  819823
]
20.24 ms
(13.64%)
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
  520890
  569427
  445182
  466085
  506050
  389973
  511691
  570521
  462799
  650487
  443274
  464703
  503965
  543812
  576643
  466207
  484601
  516393
  484484
  471056
  640029
  543343
  504604
  447618
  486531
  489461
  400854
  454322
  420311
  526737
  528071
  464322
  526083
  454542
  494786
  443761
  479040
  484914
  571680
  526077
  669276
  586015
  587530
  595061
  807340
  443812
  456369
  412583
  510750
  662896
  456883
  430303
  521260
  512831
  596966
  421181
  423320
  432886
  590959
  470772
  443763
  506997
  523040
  507540
  423336
  443767
  465335
  460731
  618803
  449180
  465355
  528258
  442771
  814431
  523169
  485691
  424056
  460745
  509481
  480742
  401140
  389612
  424443
  460750
  521516
  510571
  587817
  443760
  442494
  595931
  564786
  494557
  432831
  610311
  476344
  492719
  421207
  476342
  497337
  474016
  462319
  466118
  490262
  406217
  466101
  432172
  424675
  430255
  571210
  413100
  470560
  454251
  525349
  475121
  446811
  819823
  493093
  454317
  484377
  481591
]
2.05 ms
(1.38%)
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
  389612
  389973
  400854
  401140
  406217
  412583
  413100
  420311
  421181
  421207
  423320
  423336
  424056
  424443
  424675
  430255
  430303
  432172
  432831
  432886
  442494
  442771
  443274
  443760
  443761
  443763
  443767
  443812
  445182
  446811
  447618
  449180
  454251
  454317
  454322
  454542
  456369
  456883
  460731
  460745
  460750
  462319
  462799
  464322
  464703
  465335
  465355
  466085
  466101
  466118
  466207
  470560
  470772
  471056
  474016
  475121
  476342
  476344
  479040
  480742
  481591
  484377
  484484
  484601
  484914
  485691
  486531
  489461
  490262
  492719
  493093
  494557
  494786
  497337
  503965
  504604
  506050
  506997
  507540
  509481
  510571
  510750
  511691
  512831
  516393
  520890
  521260
  521516
  523040
  523169
  525349
  526077
  526083
  526737
  528071
  528258
  543343
  543812
  564786
  569427
  570521
  571210
  571680
  576643
  586015
  587530
  587817
  590959
  595061
  595931
  596966
  610311
  618803
  640029
  650487
  662896
  669276
  807340
  814431
  819823
]
2.04 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cunnilingus amateur hairy"
]
1.91 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "куннилингус оральн секс любительск волосатая"
]
1.53 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.