Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.23 ms
(82.58%)
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
  41433
  182435
  182754
  272725
  357457
  383701
  387293
  394648
  404172
  413404
  414676
  418827
  428773
  429518
  437708
  437791
  443244
  444540
  456127
  456699
  457812
  457815
  459388
  469078
  470073
  472394
  475417
  476050
  476672
  477503
  478028
  480211
  485280
  486243
  495211
  513221
  515253
  515259
  515272
  520763
  522156
  533841
  545677
  554907
  555236
  555771
  559749
  560913
  568479
  569725
  570911
  579206
  580397
  588236
  590713
  606127
  618592
  620957
  633463
  634180
  662856
  667254
  670956
  671531
  702336
  702341
  702342
  702357
  704425
  708570
  713143
  714438
  720593
  730073
  730102
  731758
  731762
  731794
  734844
  734852
  734868
  738482
  738486
  738499
  739174
  740310
  741157
  743745
  746116
  749593
  751486
  752292
  752532
  752550
  755936
  760471
  762561
  766294
  770258
  772077
  773308
  774811
  782823
  782942
  784641
  788646
  790442
  790479
  791895
  796266
  796687
  803611
  806444
  806543
  806650
  806687
  806965
  808644
  808994
  811329
]
16.58 ms
(10.60%)
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
  730073
  738486
  522156
  41433
  414676
  478028
  559749
  560913
  702341
  708570
  569725
  618592
  774811
  790442
  751486
  782823
  731758
  752292
  752532
  749593
  713143
  383701
  387293
  182754
  480211
  485280
  469078
  568479
  580397
  702336
  714438
  671531
  667254
  588236
  620957
  606127
  782942
  788646
  811329
  803611
  806965
  772077
  784641
  791895
  731762
  739174
  740310
  755936
  730102
  734852
  738499
  702342
  702357
  720593
  796266
  459388
  443244
  456699
  475417
  182435
  515253
  704425
  633463
  634180
  806543
  808644
  796687
  806650
  806687
  808994
  734844
  743745
  752550
  770258
  773308
  731794
  272725
  394648
  418827
  746116
  476672
  476050
  545677
  570911
  437708
  437791
  520763
  357457
  413404
  457815
  486243
  533841
  495211
  515259
  555236
  579206
  554907
  555771
  662856
  790479
  762561
  806444
  734868
  738482
  760471
  741157
  766294
  477503
  429518
  444540
  457812
  456127
  470073
  472394
  513221
  670956
  590713
  404172
  428773
  515272
]
3.44 ms
(2.20%)
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
  41433
  182435
  182754
  272725
  357457
  383701
  387293
  394648
  404172
  413404
  414676
  418827
  428773
  429518
  437708
  437791
  443244
  444540
  456127
  456699
  457812
  457815
  459388
  469078
  470073
  472394
  475417
  476050
  476672
  477503
  478028
  480211
  485280
  486243
  495211
  513221
  515253
  515259
  515272
  520763
  522156
  533841
  545677
  554907
  555236
  555771
  559749
  560913
  568479
  569725
  570911
  579206
  580397
  588236
  590713
  606127
  618592
  620957
  633463
  634180
  662856
  667254
  670956
  671531
  702336
  702341
  702342
  702357
  704425
  708570
  713143
  714438
  720593
  730073
  730102
  731758
  731762
  731794
  734844
  734852
  734868
  738482
  738486
  738499
  739174
  740310
  741157
  743745
  746116
  749593
  751486
  752292
  752532
  752550
  755936
  760471
  762561
  766294
  770258
  772077
  773308
  774811
  782823
  782942
  784641
  788646
  790442
  790479
  791895
  796266
  796687
  803611
  806444
  806543
  806650
  806687
  806965
  808644
  808994
  811329
]
1.95 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "masturbation machine"
]
1.86 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мастурбац machine"
]
1.63 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мастурбац machine"
]

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.