Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.46 ms
(80.01%)
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
  218669
  260297
  381987
  385630
  391921
  404216
  418221
  421326
  421614
  423662
  424507
  425251
  425984
  429899
  432372
  432639
  433058
  435213
  437294
  439059
  439445
  439521
  439523
  439530
  440937
  442086
  443387
  444916
  446007
  446386
  448152
  448293
  451029
  452189
  452517
  452583
  453434
  453548
  453571
  454568
  455301
  455973
  456258
  456531
  457294
  458726
  459298
  463581
  463877
  464023
  464666
  465797
  465998
  466240
  466252
  467907
  468634
  471077
  473858
  475285
  475401
  475889
  479063
  480350
  480689
  481573
  483022
  484399
  485095
  490218
  490712
  492551
  493277
  499548
  499956
  504779
  506082
  508783
  509391
  509740
  511465
  511772
  511985
  512733
  513923
  514042
  514422
  514621
  515580
  516534
  516626
  518041
  518988
  519907
  520945
  521429
  521793
  522112
  523457
  524075
  524570
  524684
  525035
  526621
  528157
  529480
  534709
  555996
  557027
  558466
  562850
  567400
  584793
  585455
  595711
  597060
  598212
  620291
  675677
  691234
]
21.53 ms
(13.41%)
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
  508783
  521793
  218669
  433058
  439521
  567400
  597060
  452189
  518988
  675677
  595711
  453434
  524570
  509740
  452517
  485095
  260297
  418221
  455973
  453571
  509391
  499548
  511772
  463581
  464666
  437294
  481573
  518041
  524684
  493277
  514422
  492551
  499956
  513923
  432639
  456531
  446386
  439530
  454568
  520945
  448293
  471077
  558466
  620291
  598212
  514621
  585455
  562850
  512733
  555996
  464023
  439059
  515580
  490712
  459298
  504779
  423662
  453548
  468634
  484399
  511985
  443387
  463877
  465797
  421326
  424507
  480350
  452583
  455301
  511465
  525035
  516534
  521429
  522112
  456258
  458726
  457294
  506082
  439445
  442086
  467907
  475401
  480689
  526621
  483022
  519907
  429899
  523457
  473858
  451029
  432372
  529480
  466240
  439523
  381987
  524075
  475889
  465998
  448152
  528157
  421614
  466252
  425251
  516626
  404216
  391921
  534709
  490218
  444916
  435213
  514042
  691234
  385630
  425984
  440937
  446007
  475285
  479063
  557027
  584793
]
2.96 ms
(1.84%)
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
  218669
  260297
  381987
  385630
  391921
  404216
  418221
  421326
  421614
  423662
  424507
  425251
  425984
  429899
  432372
  432639
  433058
  435213
  437294
  439059
  439445
  439521
  439523
  439530
  440937
  442086
  443387
  444916
  446007
  446386
  448152
  448293
  451029
  452189
  452517
  452583
  453434
  453548
  453571
  454568
  455301
  455973
  456258
  456531
  457294
  458726
  459298
  463581
  463877
  464023
  464666
  465797
  465998
  466240
  466252
  467907
  468634
  471077
  473858
  475285
  475401
  475889
  479063
  480350
  480689
  481573
  483022
  484399
  485095
  490218
  490712
  492551
  493277
  499548
  499956
  504779
  506082
  508783
  509391
  509740
  511465
  511772
  511985
  512733
  513923
  514042
  514422
  514621
  515580
  516534
  516626
  518041
  518988
  519907
  520945
  521429
  521793
  522112
  523457
  524075
  524570
  524684
  525035
  526621
  528157
  529480
  534709
  555996
  557027
  558466
  562850
  567400
  584793
  585455
  595711
  597060
  598212
  620291
  675677
  691234
]
2.38 ms
(1.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ass bra"
]
1.83 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп бюстгалтер нижн бел"
]
1.61 ms
(1.00%)
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.