Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.06 ms
(81.78%)
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
  174791
  351650
  386153
  386336
  386743
  388506
  388542
  390671
  391294
  391995
  392477
  394029
  397078
  397084
  397827
  398881
  399032
  401732
  409577
  413007
  413963
  418918
  421639
  422292
  423550
  428911
  433866
  434007
  434688
  435298
  438567
  440807
  441249
  441327
  441479
  441507
  441576
  441917
  441965
  443051
  446072
  446419
  446525
  448393
  450370
  450684
  452845
  453141
  453172
  453612
  453674
  454015
  454030
  454557
  456850
  456890
  456995
  457090
  459405
  461199
  462018
  462218
  462964
  465450
  465724
  467977
  469067
  469251
  470007
  476437
  483373
  485425
  487609
  492426
  492668
  494597
  494895
  497838
  498123
  499842
  500281
  500880
  504082
  504767
  506672
  507158
  507439
  508791
  509608
  516166
  518154
  519393
  522438
  523904
  529519
  530283
  530557
  530937
  533072
  533074
  534366
  536967
  537614
  538794
  540758
  540809
  545876
  546768
  548039
  605704
  622823
  633917
  641334
  653778
  658146
  679618
  693962
  729217
  766728
  814546
]
21.90 ms
(12.79%)
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
  548039
  658146
  679618
  693962
  633917
  605704
  729217
  391294
  388542
  441249
  450684
  470007
  487609
  494597
  498123
  483373
  492668
  485425
  453612
  519393
  516166
  536967
  508791
  518154
  540758
  546768
  545876
  653778
  641334
  440807
  476437
  391995
  522438
  448393
  622823
  766728
  386153
  386743
  386336
  174791
  394029
  392477
  351650
  388506
  390671
  397084
  397078
  397827
  399032
  398881
  401732
  418918
  434688
  438567
  441479
  441917
  422292
  433866
  434007
  441965
  423550
  441327
  409577
  413007
  421639
  435298
  443051
  413963
  428911
  441507
  441576
  540809
  814546
  446525
  461199
  467977
  469251
  492426
  446419
  453141
  453172
  453674
  454030
  454557
  457090
  459405
  462964
  446072
  450370
  452845
  454015
  456850
  456890
  456995
  462018
  462218
  500880
  504767
  507158
  523904
  530557
  537614
  497838
  499842
  504082
  533072
  538794
  506672
  507439
  529519
  530937
  534366
  494895
  500281
  509608
  530283
  533074
  465450
  465724
  469067
]
2.81 ms
(1.64%)
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
  174791
  351650
  386153
  386336
  386743
  388506
  388542
  390671
  391294
  391995
  392477
  394029
  397078
  397084
  397827
  398881
  399032
  401732
  409577
  413007
  413963
  418918
  421639
  422292
  423550
  428911
  433866
  434007
  434688
  435298
  438567
  440807
  441249
  441327
  441479
  441507
  441576
  441917
  441965
  443051
  446072
  446419
  446525
  448393
  450370
  450684
  452845
  453141
  453172
  453612
  453674
  454015
  454030
  454557
  456850
  456890
  456995
  457090
  459405
  461199
  462018
  462218
  462964
  465450
  465724
  467977
  469067
  469251
  470007
  476437
  483373
  485425
  487609
  492426
  492668
  494597
  494895
  497838
  498123
  499842
  500281
  500880
  504082
  504767
  506672
  507158
  507439
  508791
  509608
  516166
  518154
  519393
  522438
  523904
  529519
  530283
  530557
  530937
  533072
  533074
  534366
  536967
  537614
  538794
  540758
  540809
  545876
  546768
  548039
  605704
  622823
  633917
  641334
  653778
  658146
  679618
  693962
  729217
  766728
  814546
]
1.77 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "снима порн жен"
]
1.70 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "снимаю порно с женой"
]
1.59 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.84%)
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.