Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.34 ms
(51.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny big ass"
]
164.69 ms
(40.70%)
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
  388976
  397319
  409948
  410623
  414662
  416200
  419813
  432236
  443084
  443982
  447422
  470344
  478044
  481150
  484801
  485233
  485502
  489506
  496636
  500580
  500590
  501535
  517086
  523579
  525211
  525725
  529988
  534546
  537467
  540846
  541861
  541919
  542705
  547477
  547485
  547501
  548747
  550732
  551292
  552064
  553881
  554309
  554339
  556485
  557349
  557938
  558624
  558819
  559664
  559711
  561334
  562775
  567184
  567531
  567779
  568524
  569736
  571009
  572690
  573198
  576142
  578325
  578434
  579312
  580122
  581300
  581467
  582811
  586134
  586539
  588568
  588610
  588843
  589251
  593935
  597815
  598728
  598796
  600319
  601322
  603096
  603605
  605145
  605345
  606738
  610300
  617969
  617993
  619451
  645400
  647898
  659414
  660359
  660382
  662024
  668690
  674064
  680190
  681570
  702163
  714475
  718934
  719470
  722522
  728194
  730692
  732072
  741541
  743105
  743111
  745129
  753688
  762257
  799007
  804531
  807399
  810684
  811850
  814657
  825001
]
18.00 ms
(4.45%)
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
  550732
  581467
  567531
  578325
  551292
  569736
  645400
  662024
  718934
  719470
  553881
  573198
  576142
  598796
  600319
  598728
  605145
  588843
  810684
  743105
  743111
  732072
  753688
  388976
  556485
  647898
  680190
  702163
  586134
  410623
  540846
  481150
  558819
  578434
  541861
  542705
  660359
  660382
  580122
  603096
  617993
  588610
  485502
  414662
  443084
  419813
  814657
  485233
  500580
  534546
  537467
  547501
  557349
  559664
  567184
  568524
  571009
  547477
  552064
  572690
  659414
  668690
  722522
  554339
  558624
  588568
  589251
  617969
  597815
  610300
  799007
  730692
  745129
  762257
  741541
  811850
  501535
  416200
  825001
  478044
  525725
  496636
  523579
  500590
  529988
  547485
  548747
  567779
  541919
  557938
  581300
  681570
  714475
  674064
  554309
  559711
  562775
  579312
  601322
  605345
  603605
  606738
  586539
  804531
  807399
  728194
  432236
  397319
  409948
  443982
  447422
  470344
  517086
  489506
  525211
  484801
  561334
  582811
  593935
  619451
]
3.58 ms
(0.89%)
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
  388976
  397319
  409948
  410623
  414662
  416200
  419813
  432236
  443084
  443982
  447422
  470344
  478044
  481150
  484801
  485233
  485502
  489506
  496636
  500580
  500590
  501535
  517086
  523579
  525211
  525725
  529988
  534546
  537467
  540846
  541861
  541919
  542705
  547477
  547485
  547501
  548747
  550732
  551292
  552064
  553881
  554309
  554339
  556485
  557349
  557938
  558624
  558819
  559664
  559711
  561334
  562775
  567184
  567531
  567779
  568524
  569736
  571009
  572690
  573198
  576142
  578325
  578434
  579312
  580122
  581300
  581467
  582811
  586134
  586539
  588568
  588610
  588843
  589251
  593935
  597815
  598728
  598796
  600319
  601322
  603096
  603605
  605145
  605345
  606738
  610300
  617969
  617993
  619451
  645400
  647898
  659414
  660359
  660382
  662024
  668690
  674064
  680190
  681570
  702163
  714475
  718934
  719470
  722522
  728194
  730692
  732072
  741541
  743105
  743111
  745129
  753688
  762257
  799007
  804531
  807399
  810684
  811850
  814657
  825001
]
2.94 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худые большая большие жоп"
]
2.82 ms
(0.70%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые большая большие жоп"
]
2.22 ms
(0.55%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.