Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.65 ms
(86.17%)
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
  190925
  383290
  383595
  383650
  387742
  395175
  395741
  397526
  397830
  399621
  399648
  399652
  401617
  402375
  405806
  407383
  409045
  409103
  409300
  421007
  425762
  426414
  429368
  430705
  445940
  446135
  448962
  450823
  460159
  460172
  474141
  474819
  476101
  479802
  480381
  480383
  480389
  480787
  497363
  499856
  515768
  532675
  806138
  815154
  815159
  815184
  815194
  815208
  815212
  815214
  815226
  815237
  815290
  815297
  815299
  815304
  815305
  815347
  815357
  815367
  815396
  815406
  815440
  815449
  815471
  815479
  815516
  815547
  815559
  815567
  815608
  815617
  815645
  815695
  815699
  815705
  815708
  815714
  815718
  815722
  815752
  815755
  815759
  815831
  815847
  815865
  815869
  815875
  815880
  815897
  815925
  815928
  815969
  816010
  816067
  816087
  816090
  816211
  816259
  816261
  816268
  816270
  816340
  816360
  816363
  816376
  816388
  816403
  816415
  816427
  816455
  816465
  816466
  816507
  816565
  816905
  816935
  816968
  816969
  821532
]
15.24 ms
(8.66%)
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
  815831
  816010
  816268
  816270
  816360
  816388
  816403
  816415
  816427
  816465
  816935
  816969
  815154
  815226
  815396
  815440
  815479
  815695
  815722
  815880
  816090
  816211
  816340
  816363
  816376
  816455
  816466
  445940
  448962
  450823
  474819
  480381
  460159
  479802
  806138
  399621
  399648
  407383
  190925
  395175
  401617
  402375
  405806
  409045
  426414
  476101
  399652
  815297
  815290
  480787
  383290
  383595
  383650
  387742
  397526
  409103
  421007
  425762
  429368
  430705
  409300
  815305
  815357
  815367
  815516
  815547
  815617
  815714
  815897
  816507
  816905
  815194
  815304
  815608
  815755
  815969
  816067
  816261
  816968
  815159
  815214
  815299
  815449
  815471
  815559
  815645
  815699
  815708
  815718
  815869
  816087
  816565
  815184
  815208
  815212
  815237
  815347
  815406
  815567
  815705
  815752
  815759
  815847
  815865
  815875
  815925
  815928
  816259
  821532
  474141
  446135
  460172
  480389
  480383
  497363
  499856
  515768
  532675
  395741
  397830
]
2.58 ms
(1.47%)
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
  190925
  383290
  383595
  383650
  387742
  395175
  395741
  397526
  397830
  399621
  399648
  399652
  401617
  402375
  405806
  407383
  409045
  409103
  409300
  421007
  425762
  426414
  429368
  430705
  445940
  446135
  448962
  450823
  460159
  460172
  474141
  474819
  476101
  479802
  480381
  480383
  480389
  480787
  497363
  499856
  515768
  532675
  806138
  815154
  815159
  815184
  815194
  815208
  815212
  815214
  815226
  815237
  815290
  815297
  815299
  815304
  815305
  815347
  815357
  815367
  815396
  815406
  815440
  815449
  815471
  815479
  815516
  815547
  815559
  815567
  815608
  815617
  815645
  815695
  815699
  815705
  815708
  815714
  815718
  815722
  815752
  815755
  815759
  815831
  815847
  815865
  815869
  815875
  815880
  815897
  815925
  815928
  815969
  816010
  816067
  816087
  816090
  816211
  816259
  816261
  816268
  816270
  816340
  816360
  816363
  816376
  816388
  816403
  816415
  816427
  816455
  816465
  816466
  816507
  816565
  816905
  816935
  816968
  816969
  821532
]
1.80 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf brazzers"
]
1.66 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf brazzers"
]
1.47 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf brazzers"
]

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.