Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
214.67 ms
(89.17%)
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
  381823
  391597
  396809
  398558
  416416
  416868
  419201
  420486
  426256
  426668
  428552
  428693
  429484
  431465
  445097
  446150
  447241
  448897
  450664
  452427
  452925
  454386
  455693
  455757
  457254
  459400
  464967
  465319
  467013
  470032
  470061
  473786
  475767
  477247
  480229
  483479
  483723
  484911
  485383
  485421
  491109
  491111
  492423
  492424
  495042
  498181
  499291
  499307
  500222
  500700
  509863
  510327
  510594
  511034
  513166
  513208
  517540
  518613
  518784
  519912
  520183
  521268
  522455
  531870
  534135
  538559
  544799
  544957
  545057
  546556
  558113
  558173
  566728
  568300
  584331
  600213
  601652
  601825
  602989
  622950
  624351
  648005
  668824
  671545
  671698
  676412
  683297
  700309
  707687
  714820
  728530
  730951
  730965
  733105
  736191
  743789
  757225
  763444
  771347
  771939
  781925
  782595
  789605
  794223
  794755
  795273
  795703
  796501
  799074
  804031
  804800
  813865
  817583
  817599
  819347
  820764
  823886
  823893
  824107
]
15.77 ms
(6.55%)
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
  600213
  602989
  736191
  763444
  771939
  757225
  480229
  426668
  491109
  470061
  447241
  483479
  513166
  520183
  545057
  558173
  683297
  707687
  601825
  446150
  477247
  420486
  452427
  457254
  470032
  491111
  500222
  518613
  519912
  498181
  522455
  416868
  464967
  544799
  648005
  676412
  700309
  517540
  817583
  819347
  823893
  817599
  820764
  824107
  813865
  823886
  544957
  668824
  714820
  671698
  795703
  782595
  794755
  795273
  796501
  804031
  730951
  733105
  743789
  771347
  799074
  381823
  396809
  398558
  419201
  428693
  445097
  429484
  416416
  473786
  475767
  467013
  483723
  485383
  492424
  521268
  531870
  538559
  510594
  534135
  499307
  465319
  584331
  566728
  568300
  671545
  622950
  624351
  601652
  789605
  804800
  391597
  431465
  454386
  450664
  428552
  448897
  452925
  455693
  495042
  499291
  509863
  484911
  492423
  500700
  510327
  485421
  513208
  426256
  455757
  511034
  518784
  558113
  546556
  619032
  794223
  730965
  728530
  781925
  459400
]
3.05 ms
(1.26%)
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
  381823
  391597
  396809
  398558
  416416
  416868
  419201
  420486
  426256
  426668
  428552
  428693
  429484
  431465
  445097
  446150
  447241
  448897
  450664
  452427
  452925
  454386
  455693
  455757
  457254
  459400
  464967
  465319
  467013
  470032
  470061
  473786
  475767
  477247
  480229
  483479
  483723
  484911
  485383
  485421
  491109
  491111
  492423
  492424
  495042
  498181
  499291
  499307
  500222
  500700
  509863
  510327
  510594
  511034
  513166
  513208
  517540
  518613
  518784
  519912
  520183
  521268
  522455
  531870
  534135
  538559
  544799
  544957
  545057
  546556
  558113
  558173
  566728
  568300
  584331
  600213
  601652
  601825
  602989
  622950
  624351
  648005
  668824
  671545
  671698
  676412
  683297
  700309
  707687
  714820
  728530
  730951
  730965
  733105
  736191
  743789
  757225
  763444
  771347
  771939
  781925
  782595
  789605
  794223
  794755
  795273
  795703
  796501
  799074
  804031
  804800
  813865
  817583
  817599
  819347
  820764
  823886
  823893
  824107
]
1.96 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "saggy webcam"
]
1.94 ms
(0.80%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(0.76%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "saggy вебкамер"
]
1.53 ms
(0.63%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "saggy вебкамер"
]

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.