Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
161.80 ms
(83.84%)
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
  382238
  382530
  382604
  387664
  388259
  388639
  388681
  396441
  397255
  397354
  399835
  414340
  417226
  423632
  457086
  458988
  461526
  467270
  472372
  474860
  475845
  478317
  485040
  486359
  500593
  502895
  508833
  508850
  509114
  513027
  523971
  527035
  531325
  543759
  548678
  552581
  553245
  557469
  561707
  563766
  564750
  568313
  568449
  569035
  569120
  569222
  569482
  569534
  570420
  573790
  574022
  574890
  574892
  575727
  578456
  585380
  586628
  603913
  607481
  615719
  628375
  636232
  650104
  668886
  673326
  679037
  679040
  679041
  684947
  692296
  692651
  707333
  710286
  710960
  714156
  716329
  717645
  719461
  719964
  733672
  742211
  742632
  745027
  748491
  754206
  758332
  761300
  761997
  763032
  767329
  768739
  770790
  772249
  775440
  777784
  779687
  780930
  781701
  785033
  787973
  788650
  789166
  794794
  795137
  797555
  799712
  799725
  800042
  802953
  803745
  808112
  810187
  811347
  814092
  814330
  814797
  818002
  819611
  820850
  827590
]
22.57 ms
(11.70%)
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
  563766
  781701
  785033
  800042
  811347
  745027
  761997
  754206
  758332
  603913
  719964
  779687
  780930
  797555
  397255
  527035
  770790
  417226
  472372
  478317
  768739
  802953
  382530
  553245
  795137
  814330
  485040
  382604
  382238
  820850
  564750
  794794
  569120
  615719
  509114
  679037
  679040
  819611
  388259
  500593
  548678
  719461
  573790
  461526
  568313
  679041
  475845
  673326
  714156
  777784
  803745
  775440
  763032
  742632
  761300
  748491
  767329
  788650
  399835
  569035
  552581
  457086
  575727
  570420
  710286
  585380
  607481
  508850
  827590
  574892
  684947
  578456
  733672
  423632
  814092
  818002
  716329
  692651
  557469
  569534
  636232
  789166
  799712
  810187
  742211
  772249
  787973
  799725
  808112
  707333
  388681
  414340
  474860
  574022
  561707
  568449
  467270
  502895
  486359
  531325
  717645
  710960
  523971
  397354
  628375
  513027
  586628
  388639
  387664
  458988
  574890
  668886
  508833
  396441
  814797
  569222
  543759
  569482
  650104
  692296
]
2.92 ms
(1.52%)
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
  382238
  382530
  382604
  387664
  388259
  388639
  388681
  396441
  397255
  397354
  399835
  414340
  417226
  423632
  457086
  458988
  461526
  467270
  472372
  474860
  475845
  478317
  485040
  486359
  500593
  502895
  508833
  508850
  509114
  513027
  523971
  527035
  531325
  543759
  548678
  552581
  553245
  557469
  561707
  563766
  564750
  568313
  568449
  569035
  569120
  569222
  569482
  569534
  570420
  573790
  574022
  574890
  574892
  575727
  578456
  585380
  586628
  603913
  607481
  615719
  628375
  636232
  650104
  668886
  673326
  679037
  679040
  679041
  684947
  692296
  692651
  707333
  710286
  710960
  714156
  716329
  717645
  719461
  719964
  733672
  742211
  742632
  745027
  748491
  754206
  758332
  761300
  761997
  763032
  767329
  768739
  770790
  772249
  775440
  777784
  779687
  780930
  781701
  785033
  787973
  788650
  789166
  794794
  795137
  797555
  799712
  799725
  800042
  802953
  803745
  808112
  810187
  811347
  814092
  814330
  814797
  818002
  819611
  820850
  827590
]
1.55 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dirty blowjob"
]
1.53 ms
(0.79%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.36 ms
(0.70%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "dirty минет оральн секс"
]
1.24 ms
(0.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "dirty минет оральн секс"
]

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.