Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
175.31 ms
(86.90%)
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
  28294
  152157
  305892
  387941
  401440
  418628
  423384
  428374
  428582
  430742
  430815
  431002
  445086
  448396
  457195
  459443
  461253
  463212
  468961
  473865
  476335
  476780
  479200
  481327
  481963
  483092
  486823
  495472
  500266
  505073
  506314
  507354
  512816
  513709
  521466
  521826
  522165
  524487
  525865
  526429
  526636
  528689
  528773
  528907
  529349
  531016
  531483
  531599
  532065
  532348
  532510
  534124
  538991
  544525
  545304
  545609
  546510
  548383
  549485
  550574
  553852
  554549
  554782
  554793
  556247
  556673
  557144
  557467
  558017
  558318
  558794
  559000
  559558
  561081
  563906
  569142
  570036
  572136
  573428
  573724
  577814
  581619
  581825
  584774
  585697
  586172
  586680
  587576
  588151
  590987
  591286
  593053
  594195
  595363
  595828
  596272
  597171
  597922
  602417
  603031
  603160
  606921
  607353
  607376
  608827
  623835
  626283
  636219
  637492
  641481
  655406
  655689
  665205
  667226
  667497
  669589
  678966
  681393
  684335
  685447
]
15.75 ms
(7.81%)
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
  596272
  448396
  526636
  573428
  581619
  678966
  636219
  431002
  152157
  418628
  428374
  401440
  463212
  481963
  305892
  681393
  606921
  549485
  512816
  525865
  538991
  528773
  534124
  532510
  524487
  479200
  548383
  544525
  554782
  557144
  559558
  561081
  685447
  667226
  545304
  558017
  608827
  585697
  637492
  591286
  430815
  468961
  500266
  506314
  528907
  577814
  553852
  476335
  513709
  28294
  532065
  507354
  521466
  573724
  554549
  669589
  593053
  457195
  486823
  569142
  558794
  597171
  428582
  529349
  531016
  570036
  572136
  684335
  655406
  655689
  546510
  550574
  586172
  603160
  461253
  430742
  459443
  473865
  483092
  481327
  521826
  603031
  607353
  387941
  528689
  532348
  476780
  526429
  495472
  522165
  505073
  584774
  558318
  563906
  665205
  556673
  557467
  590987
  623835
  597922
  595828
  531483
  531599
  554793
  556247
  559000
  581825
  667497
  607376
  594195
  587576
  641481
  602417
  588151
  545609
  586680
  595363
  626283
  445086
  423384
]
4.21 ms
(2.09%)
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
  28294
  152157
  305892
  387941
  401440
  418628
  423384
  428374
  428582
  430742
  430815
  431002
  445086
  448396
  457195
  459443
  461253
  463212
  468961
  473865
  476335
  476780
  479200
  481327
  481963
  483092
  486823
  495472
  500266
  505073
  506314
  507354
  512816
  513709
  521466
  521826
  522165
  524487
  525865
  526429
  526636
  528689
  528773
  528907
  529349
  531016
  531483
  531599
  532065
  532348
  532510
  534124
  538991
  544525
  545304
  545609
  546510
  548383
  549485
  550574
  553852
  554549
  554782
  554793
  556247
  556673
  557144
  557467
  558017
  558318
  558794
  559000
  559558
  561081
  563906
  569142
  570036
  572136
  573428
  573724
  577814
  581619
  581825
  584774
  585697
  586172
  586680
  587576
  588151
  590987
  591286
  593053
  594195
  595363
  595828
  596272
  597171
  597922
  602417
  603031
  603160
  606921
  607353
  607376
  608827
  623835
  626283
  636219
  637492
  641481
  655406
  655689
  665205
  667226
  667497
  669589
  678966
  681393
  684335
  685447
]
2.09 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "пирсинг большие сиськ…"
]
1.53 ms
(0.76%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пирсинг большие сиськ"
]
1.44 ms
(0.72%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.40 ms
(0.69%)
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.