Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.40 ms
(81.86%)
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
  360336
  387647
  389642
  398193
  398477
  400363
  418360
  423833
  432507
  432517
  432564
  433051
  433271
  433390
  433447
  433584
  433930
  434093
  435560
  438397
  442431
  444352
  446872
  448468
  452754
  454470
  455042
  456153
  457013
  458522
  460033
  460370
  463448
  464643
  467041
  469620
  472971
  473320
  479389
  479619
  479889
  481756
  484778
  485139
  485862
  485878
  494180
  496127
  497800
  500059
  501954
  505732
  509324
  509704
  511288
  518506
  518761
  520939
  521360
  523422
  527635
  536125
  549222
  552355
  560872
  563880
  575233
  577934
  579174
  587011
  592045
  601183
  601322
  602063
  612607
  615431
  616910
  626798
  636353
  646000
  678896
  682269
  692510
  695048
  702239
  704017
  707196
  707510
  710240
  723252
  725467
  731521
  735382
  743471
  743891
  747248
  759926
  760530
  762327
  763141
  764574
  775083
  779278
  782695
  785316
  791453
  792136
  795272
  796538
  797720
  802150
  802163
  805005
  808536
  810614
  811313
  814395
  817891
  817970
  819337
]
17.19 ms
(11.40%)
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
  418360
  423833
  433051
  467041
  457013
  469620
  479389
  481756
  435560
  444352
  456153
  472971
  442431
  463448
  485139
  494180
  505732
  432517
  592045
  458522
  448468
  454470
  479889
  433447
  501954
  518506
  521360
  552355
  500059
  433930
  527635
  563880
  682269
  360336
  398193
  400363
  814395
  536125
  496127
  511288
  577934
  646000
  702239
  704017
  707196
  723252
  707510
  695048
  710240
  626798
  785316
  802150
  808536
  779278
  782695
  792136
  795272
  802163
  805005
  747248
  763141
  764574
  811313
  725467
  743471
  762327
  760530
  759926
  731521
  735382
  791453
  797720
  810614
  432564
  460033
  579174
  518761
  575233
  438397
  455042
  497800
  523422
  549222
  615431
  616910
  433584
  460370
  389642
  387647
  452754
  520939
  601183
  775083
  796538
  509704
  678896
  743891
  432507
  434093
  485878
  602063
  601322
  819337
  485862
  446872
  612607
  587011
  464643
  509324
  473320
  433271
  479619
  560872
  636353
  398477
  433390
  484778
  692510
  817891
  817970
]
2.53 ms
(1.68%)
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
  360336
  387647
  389642
  398193
  398477
  400363
  418360
  423833
  432507
  432517
  432564
  433051
  433271
  433390
  433447
  433584
  433930
  434093
  435560
  438397
  442431
  444352
  446872
  448468
  452754
  454470
  455042
  456153
  457013
  458522
  460033
  460370
  463448
  464643
  467041
  469620
  472971
  473320
  479389
  479619
  479889
  481756
  484778
  485139
  485862
  485878
  494180
  496127
  497800
  500059
  501954
  505732
  509324
  509704
  511288
  518506
  518761
  520939
  521360
  523422
  527635
  536125
  549222
  552355
  560872
  563880
  575233
  577934
  579174
  587011
  592045
  601183
  601322
  602063
  612607
  615431
  616910
  626798
  636353
  646000
  678896
  682269
  692510
  695048
  702239
  704017
  707196
  707510
  710240
  723252
  725467
  731521
  735382
  743471
  743891
  747248
  759926
  760530
  762327
  763141
  764574
  775083
  779278
  782695
  785316
  791453
  792136
  795272
  796538
  797720
  802150
  802163
  805005
  808536
  810614
  811313
  814395
  817891
  817970
  819337
]
2.22 ms
(1.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cum to panties"
]
1.93 ms
(1.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cum трусик нижн бел"
]
1.82 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cum трусик нижн бел"
]
1.67 ms
(1.11%)
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.