Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.28 ms
(87.02%)
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
  381982
  389840
  398244
  411702
  411722
  424220
  424431
  426503
  442211
  452345
  458002
  465672
  467435
  469146
  470938
  475279
  480300
  482371
  482795
  484756
  486757
  490744
  491320
  510948
  513501
  515271
  517712
  520343
  523161
  529691
  532271
  533976
  534634
  534710
  540952
  544615
  547443
  549965
  557171
  560400
  569423
  569426
  569975
  571695
  573226
  573244
  574386
  580265
  580739
  583514
  584201
  584380
  586442
  586535
  588155
  589752
  601619
  601914
  603378
  603399
  604754
  605233
  607185
  607224
  617115
  618391
  625227
  641705
  650266
  650510
  661039
  663982
  665264
  669057
  669324
  669874
  673420
  678805
  695691
  705531
  715373
  716221
  725537
  736634
  741194
  741688
  741692
  741739
  742410
  747949
  748177
  755776
  757695
  759695
  759845
  759866
  770853
  771557
  771944
  784235
  788121
  789474
  789534
  797032
  798926
  799054
  799986
  800657
  800676
  802555
  803463
  808873
  811069
  815590
  819646
  820178
  823336
  824145
  824456
  826508
]
13.08 ms
(7.52%)
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
  580739
  669324
  673420
  695691
  603399
  588155
  741688
  741692
  741739
  742410
  603378
  470938
  469146
  515271
  819646
  820178
  826508
  823336
  824145
  815590
  465672
  533976
  534634
  529691
  534710
  484756
  549965
  544615
  547443
  557171
  573244
  583514
  584201
  650510
  669874
  650266
  661039
  569975
  571695
  573226
  601619
  605233
  799986
  800676
  789474
  797032
  800657
  808873
  741194
  755776
  771944
  784235
  811069
  736634
  748177
  759866
  747949
  757695
  771557
  607224
  705531
  788121
  798926
  799054
  802555
  540952
  574386
  665264
  678805
  520343
  523161
  398244
  411702
  442211
  824456
  490744
  458002
  480300
  452345
  510948
  517712
  532271
  482371
  569423
  584380
  569426
  580265
  716221
  663982
  669057
  586442
  607185
  641705
  589752
  601914
  604754
  586535
  618391
  625227
  789534
  770853
  803463
  759845
  725537
  759695
  715373
  381982
  424431
  389840
  467435
  426503
  475279
  411722
  491320
  486757
  513501
  482795
  424220
  617115
  560400
]
3.06 ms
(1.76%)
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
  381982
  389840
  398244
  411702
  411722
  424220
  424431
  426503
  442211
  452345
  458002
  465672
  467435
  469146
  470938
  475279
  480300
  482371
  482795
  484756
  486757
  490744
  491320
  510948
  513501
  515271
  517712
  520343
  523161
  529691
  532271
  533976
  534634
  534710
  540952
  544615
  547443
  549965
  557171
  560400
  569423
  569426
  569975
  571695
  573226
  573244
  574386
  580265
  580739
  583514
  584201
  584380
  586442
  586535
  588155
  589752
  601619
  601914
  603378
  603399
  604754
  605233
  607185
  607224
  617115
  618391
  625227
  641705
  650266
  650510
  661039
  663982
  665264
  669057
  669324
  669874
  673420
  678805
  695691
  705531
  715373
  716221
  725537
  736634
  741194
  741688
  741692
  741739
  742410
  747949
  748177
  755776
  757695
  759695
  759845
  759866
  770853
  771557
  771944
  784235
  788121
  789474
  789534
  797032
  798926
  799054
  799986
  800657
  800676
  802555
  803463
  808873
  811069
  815590
  819646
  820178
  823336
  824145
  824456
  826508
]
1.87 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "зрелая очки"
]
1.64 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "зрелая женщин очкастые"
]
1.59 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.32 ms
(0.76%)
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.