Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
116.88 ms
(82.61%)
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
  191759
  275759
  383388
  389460
  389867
  395655
  396782
  400619
  401160
  428728
  450392
  458503
  459848
  474224
  516016
  526102
  538578
  538705
  538721
  538757
  538779
  538782
  545358
  550585
  552291
  555052
  557446
  558392
  560369
  568776
  574026
  579785
  587157
  589927
  594159
  594170
  594232
  594250
  597284
  597545
  600335
  600757
  601776
  604215
  604900
  605591
  621453
  621469
  621958
  622592
  624264
  625793
  628756
  628843
  629574
  629629
  635883
  636175
  649372
  662499
  664260
  664555
  668485
  670896
  709276
  712153
  740131
  740258
  750392
  751805
  753745
  754318
  754447
  754487
  754574
  756670
  759115
  768053
  769163
  770456
  771753
  771944
  771984
  776576
  782475
  782554
  783327
  783863
  784001
  784022
  784033
  784044
  784379
  784410
  784453
  784654
  785908
  791198
  794197
  795219
  796576
  797333
  800954
  803624
  804254
  807003
  807583
  808087
  808107
  808529
  808540
  808561
  808697
  809143
  811415
  812804
  818751
  819649
  823827
  826160
]
14.26 ms
(10.08%)
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
  771944
  808087
  768053
  474224
  552291
  649372
  621453
  594159
  812804
  756670
  771753
  797333
  808529
  597284
  450392
  818751
  589927
  740258
  754318
  459848
  625793
  754447
  400619
  597545
  605591
  389867
  538782
  629629
  791198
  807003
  808561
  754487
  784001
  784379
  807583
  622592
  712153
  826160
  823827
  538578
  557446
  545358
  560369
  664555
  668485
  709276
  600757
  604900
  628843
  594170
  809143
  796576
  750392
  753745
  389460
  383388
  191759
  395655
  538705
  538757
  555052
  635883
  600335
  782475
  794197
  800954
  771984
  784410
  769163
  759115
  740131
  624264
  784044
  401160
  428728
  458503
  594250
  396782
  538779
  636175
  601776
  628756
  587157
  784453
  803624
  808540
  784022
  785908
  751805
  754574
  629574
  784033
  526102
  604215
  784654
  275759
  538721
  516016
  558392
  574026
  670896
  621469
  621958
  594232
  811415
  782554
  783327
  795219
  808107
  808697
  770456
  776576
  783863
  804254
  819649
  550585
  579785
  568776
  662499
  664260
]
3.09 ms
(2.19%)
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
  191759
  275759
  383388
  389460
  389867
  395655
  396782
  400619
  401160
  428728
  450392
  458503
  459848
  474224
  516016
  526102
  538578
  538705
  538721
  538757
  538779
  538782
  545358
  550585
  552291
  555052
  557446
  558392
  560369
  568776
  574026
  579785
  587157
  589927
  594159
  594170
  594232
  594250
  597284
  597545
  600335
  600757
  601776
  604215
  604900
  605591
  621453
  621469
  621958
  622592
  624264
  625793
  628756
  628843
  629574
  629629
  635883
  636175
  649372
  662499
  664260
  664555
  668485
  670896
  709276
  712153
  740131
  740258
  750392
  751805
  753745
  754318
  754447
  754487
  754574
  756670
  759115
  768053
  769163
  770456
  771753
  771944
  771984
  776576
  782475
  782554
  783327
  783863
  784001
  784022
  784033
  784044
  784379
  784410
  784453
  784654
  785908
  791198
  794197
  795219
  796576
  797333
  800954
  803624
  804254
  807003
  807583
  808087
  808107
  808529
  808540
  808561
  808697
  809143
  811415
  812804
  818751
  819649
  823827
  826160
]
2.05 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam busty girl"
]
1.88 ms
(1.33%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вебкамер busty девушк"
]
1.69 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вебкамер busty девушк"
]

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.