Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.27 ms
(85.50%)
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
  7502
  8518
  43250
  97107
  341608
  373798
  386062
  393677
  395696
  397232
  398666
  399418
  403255
  408711
  421637
  467606
  471476
  473764
  506321
  509802
  532756
  545453
  549785
  550264
  550563
  551057
  609875
  610577
  620785
  621029
  629243
  632423
  633895
  637016
  640523
  642700
  644274
  644275
  649133
  652966
  653888
  654078
  665927
  666546
  670997
  672130
  672388
  673371
  674733
  681804
  683564
  683584
  685819
  686501
  688660
  690749
  693049
  694447
  695096
  695930
  696250
  697361
  697785
  697839
  697973
  697987
  698597
  699632
  699667
  699755
  700282
  703037
  703055
  703095
  705520
  705829
  709259
  715176
  715818
  717636
  717805
  719057
  720202
  721318
  722607
  722655
  723468
  728327
  733870
  737516
  738812
  739012
  741213
  742363
  750154
  752785
  759485
  766611
  767283
  769418
  772729
  775798
  775922
  775931
  782836
  784324
  784732
  787628
  791772
  793899
  795137
  802471
  802477
  802732
  803399
  809050
  810914
  814423
  817423
  827829
]
14.19 ms
(8.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
  621029
  633895
  775798
  782836
  795137
  802732
  803399
  809050
  775922
  787628
  793899
  802471
  750154
  767283
  769418
  772729
  784324
  802477
  810914
  728327
  737516
  742363
  752785
  741213
  759485
  738812
  739012
  766611
  609875
  620785
  629243
  632423
  640523
  644274
  644275
  697987
  703037
  703095
  705829
  715176
  717805
  775931
  784732
  791772
  8518
  408711
  373798
  403255
  471476
  473764
  642700
  395696
  509802
  532756
  666546
  610577
  637016
  733870
  386062
  393677
  341608
  97107
  43250
  7502
  397232
  398666
  399418
  421637
  814423
  817423
  827829
  467606
  506321
  545453
  549785
  551057
  550563
  652966
  653888
  654078
  670997
  686501
  688660
  695930
  696250
  697785
  697839
  697973
  700282
  721318
  672130
  672388
  683564
  695096
  697361
  698597
  705520
  709259
  715818
  717636
  722607
  722655
  723468
  649133
  665927
  673371
  674733
  681804
  683584
  685819
  690749
  693049
  694447
  699632
  699667
  699755
  703055
  719057
  720202
  550264
]
2.79 ms
(1.65%)
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
  7502
  8518
  43250
  97107
  341608
  373798
  386062
  393677
  395696
  397232
  398666
  399418
  403255
  408711
  421637
  467606
  471476
  473764
  506321
  509802
  532756
  545453
  549785
  550264
  550563
  551057
  609875
  610577
  620785
  621029
  629243
  632423
  633895
  637016
  640523
  642700
  644274
  644275
  649133
  652966
  653888
  654078
  665927
  666546
  670997
  672130
  672388
  673371
  674733
  681804
  683564
  683584
  685819
  686501
  688660
  690749
  693049
  694447
  695096
  695930
  696250
  697361
  697785
  697839
  697973
  697987
  698597
  699632
  699667
  699755
  700282
  703037
  703055
  703095
  705520
  705829
  709259
  715176
  715818
  717636
  717805
  719057
  720202
  721318
  722607
  722655
  723468
  728327
  733870
  737516
  738812
  739012
  741213
  742363
  750154
  752785
  759485
  766611
  767283
  769418
  772729
  775798
  775922
  775931
  782836
  784324
  784732
  787628
  791772
  793899
  795137
  802471
  802477
  802732
  803399
  809050
  810914
  814423
  817423
  827829
]
2.27 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "double penetration teens"
]
1.81 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "double penetration teens"
]
1.77 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "double penetration teens"
]
1.63 ms
(0.97%)
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.