Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
170.55 ms
(84.28%)
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
  193462
  383580
  391678
  410299
  415874
  416593
  417430
  429931
  435373
  435376
  443239
  447508
  451727
  452421
  454115
  460308
  462618
  469508
  478489
  499179
  516460
  522082
  529498
  531332
  531351
  537051
  539275
  544080
  552697
  557462
  566873
  581249
  585827
  599349
  601375
  601509
  604109
  604186
  604226
  604291
  608295
  619205
  620907
  624156
  626678
  633650
  648410
  654909
  656893
  659956
  659960
  661967
  665899
  675612
  675859
  685531
  693441
  700250
  701445
  705459
  705472
  715014
  715035
  715396
  715896
  718102
  720285
  720706
  723191
  725009
  726264
  729290
  730362
  731300
  731552
  731836
  734928
  736196
  736283
  739927
  750278
  756657
  758504
  762761
  762771
  764817
  765097
  765098
  765104
  765367
  765760
  765940
  766672
  766866
  767154
  767186
  770315
  770592
  777013
  778893
  778934
  779695
  781368
  782122
  782446
  783428
  788661
  789219
  791525
  793449
  795920
  796486
  797194
  801648
  804693
  810378
  813947
  814533
  814998
  824049
]
20.57 ms
(10.16%)
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
  601509
  764817
  544080
  604226
  435376
  416593
  417430
  451727
  537051
  700250
  604109
  452421
  478489
  435373
  516460
  581249
  824049
  715896
  659956
  705472
  585827
  624156
  796486
  762761
  447508
  383580
  193462
  410299
  814533
  814998
  531332
  460308
  557462
  659960
  675612
  718102
  715035
  654909
  665899
  601375
  619205
  620907
  626678
  633650
  778893
  778934
  804693
  781368
  788661
  795920
  729290
  736283
  758504
  765097
  765098
  765104
  767154
  767186
  770592
  782122
  791525
  793449
  797194
  810378
  731300
  766672
  726264
  730362
  739927
  762771
  765760
  731836
  736196
  734928
  750278
  765367
  770315
  608295
  715396
  720285
  720706
  391678
  566873
  552697
  604291
  415874
  766866
  443239
  469508
  429931
  801648
  779695
  531351
  705459
  604186
  756657
  789219
  454115
  462618
  522082
  499179
  539275
  599349
  777013
  782446
  725009
  731552
  715014
  661967
  783428
  765940
  813947
  529498
  675859
  685531
  693441
  701445
  723191
  648410
  656893
]
3.61 ms
(1.79%)
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
  193462
  383580
  391678
  410299
  415874
  416593
  417430
  429931
  435373
  435376
  443239
  447508
  451727
  452421
  454115
  460308
  462618
  469508
  478489
  499179
  516460
  522082
  529498
  531332
  531351
  537051
  539275
  544080
  552697
  557462
  566873
  581249
  585827
  599349
  601375
  601509
  604109
  604186
  604226
  604291
  608295
  619205
  620907
  624156
  626678
  633650
  648410
  654909
  656893
  659956
  659960
  661967
  665899
  675612
  675859
  685531
  693441
  700250
  701445
  705459
  705472
  715014
  715035
  715396
  715896
  718102
  720285
  720706
  723191
  725009
  726264
  729290
  730362
  731300
  731552
  731836
  734928
  736196
  736283
  739927
  750278
  756657
  758504
  762761
  762771
  764817
  765097
  765098
  765104
  765367
  765760
  765940
  766672
  766866
  767154
  767186
  770315
  770592
  777013
  778893
  778934
  779695
  781368
  782122
  782446
  783428
  788661
  789219
  791525
  793449
  795920
  796486
  797194
  801648
  804693
  810378
  813947
  814533
  814998
  824049
]
2.07 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam anal fuck"
]
1.99 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.85 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вебкамер анал секс"
]
1.71 ms
(0.85%)
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.