Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
188.39 ms
(87.09%)
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
  384804
  386253
  398713
  428399
  437761
  437959
  442164
  469900
  473268
  475010
  482333
  482444
  484253
  490461
  491082
  491387
  494676
  495257
  495898
  496123
  497054
  497652
  497654
  498345
  504853
  506316
  511725
  515825
  518553
  520987
  521447
  522293
  522584
  523938
  523953
  523962
  524510
  525951
  526659
  526740
  527711
  529298
  529864
  531154
  535058
  538119
  538583
  539300
  540233
  544056
  544116
  547429
  549175
  550650
  551201
  551710
  553331
  554251
  555434
  555756
  560178
  560273
  560746
  560768
  561191
  564481
  565450
  567235
  568983
  569135
  569153
  570764
  571065
  571077
  571864
  571933
  574659
  576724
  577074
  578132
  578865
  579717
  581035
  582722
  586331
  586424
  588896
  590447
  592457
  594505
  604278
  604424
  605218
  609318
  614133
  614260
  614365
  617025
  619012
  625382
  626145
  626154
  635752
  647109
  650031
  661280
  661889
  673101
  682625
  703547
  704351
  705712
  705770
  705781
  709938
  712672
  736153
  776426
  784440
  798748
]
12.03 ms
(5.56%)
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
  605218
  626154
  588896
  784440
  551710
  705770
  704351
  565450
  626145
  495257
  551201
  703547
  682625
  398713
  437761
  578865
  544116
  386253
  661889
  550650
  553331
  569135
  571933
  635752
  520987
  527711
  497054
  736153
  442164
  647109
  539300
  549175
  614260
  560768
  609318
  571077
  568983
  515825
  540233
  560746
  554251
  560273
  571864
  576724
  547429
  523938
  522584
  798748
  495898
  518553
  506316
  482444
  496123
  529298
  535058
  482333
  586424
  494676
  538119
  497654
  619012
  526740
  570764
  484253
  526659
  579717
  614133
  571065
  544056
  582722
  590447
  529864
  614365
  705781
  712672
  650031
  604278
  469900
  705712
  625382
  523962
  581035
  475010
  428399
  574659
  673101
  384804
  524510
  555756
  776426
  567235
  491082
  564481
  523953
  521447
  525951
  661280
  604424
  617025
  586331
  522293
  594505
  498345
  569153
  531154
  560178
  511725
  437959
  561191
  538583
  555434
  504853
  592457
  491387
  497652
  709938
  577074
  473268
  578132
  490461
]
6.13 ms
(2.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
3.37 ms
(1.56%)
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
  384804
  386253
  398713
  428399
  437761
  437959
  442164
  469900
  473268
  475010
  482333
  482444
  484253
  490461
  491082
  491387
  494676
  495257
  495898
  496123
  497054
  497652
  497654
  498345
  504853
  506316
  511725
  515825
  518553
  520987
  521447
  522293
  522584
  523938
  523953
  523962
  524510
  525951
  526659
  526740
  527711
  529298
  529864
  531154
  535058
  538119
  538583
  539300
  540233
  544056
  544116
  547429
  549175
  550650
  551201
  551710
  553331
  554251
  555434
  555756
  560178
  560273
  560746
  560768
  561191
  564481
  565450
  567235
  568983
  569135
  569153
  570764
  571065
  571077
  571864
  571933
  574659
  576724
  577074
  578132
  578865
  579717
  581035
  582722
  586331
  586424
  588896
  590447
  592457
  594505
  604278
  604424
  605218
  609318
  614133
  614260
  614365
  617025
  619012
  625382
  626145
  626154
  635752
  647109
  650031
  661280
  661889
  673101
  682625
  703547
  704351
  705712
  705770
  705781
  709938
  712672
  736153
  776426
  784440
  798748
]
2.38 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "секс лес"
]
2.05 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс лес природ"
]
1.98 ms
(0.91%)
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.