Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.01 ms
(87.27%)
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
  3638
  7240
  385464
  386893
  389525
  403147
  406067
  460083
  461474
  464166
  468151
  468345
  481718
  497903
  509365
  516357
  529639
  545780
  548411
  562187
  572208
  586657
  596686
  600208
  602067
  609634
  611282
  622677
  625360
  628469
  629631
  636873
  640319
  646066
  650070
  654286
  658943
  659262
  660336
  664417
  666067
  672820
  675613
  677903
  677919
  680259
  683420
  690703
  701427
  703968
  705788
  706211
  707149
  708747
  710261
  712846
  715907
  716796
  717122
  717159
  720015
  721264
  724795
  725641
  725779
  726920
  728060
  730360
  736444
  739521
  740037
  742202
  742312
  742939
  744378
  746293
  750864
  752509
  759008
  760874
  762675
  765341
  765717
  766711
  767377
  769287
  770998
  771986
  772863
  779317
  779513
  780583
  781486
  784299
  786477
  787927
  790806
  791475
  791530
  794337
  794877
  795504
  797438
  797840
  799508
  799549
  799742
  800050
  801547
  801574
  802806
  808084
  808855
  809874
  817940
  819779
  819948
  820378
  820540
]
11.44 ms
(7.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
  464166
  460083
  548411
  680259
  706211
  721264
  650070
  602067
  596686
  600208
  797438
  801547
  746293
  765341
  762326
  766711
  744378
  730360
  739521
  750864
  622677
  701427
  703968
  717122
  794337
  403147
  461474
  468345
  677903
  791475
  799742
  801574
  779513
  781486
  784299
  736444
  742202
  725779
  795504
  7240
  819779
  820540
  817940
  660336
  712846
  715907
  664417
  675613
  717159
  629631
  628469
  586657
  611282
  636873
  790806
  791530
  780583
  725641
  742312
  772863
  724795
  742939
  759008
  786477
  797840
  516357
  800050
  659262
  787927
  752509
  740037
  799508
  389525
  386893
  672820
  707149
  716796
  809874
  728060
  802806
  406067
  819948
  820378
  509365
  710261
  654286
  625360
  640319
  779317
  794877
  808084
  808855
  726920
  760874
  770998
  771986
  762675
  765717
  767377
  769287
  609634
  799549
  385464
  3638
  468151
  481718
  529639
  497903
  572208
  545780
  562187
  690703
  705788
  658943
  666067
  683420
  708747
  720015
  646066
  677919
]
2.38 ms
(1.47%)
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
  3638
  7240
  385464
  386893
  389525
  403147
  406067
  460083
  461474
  464166
  468151
  468345
  481718
  497903
  509365
  516357
  529639
  545780
  548411
  562187
  572208
  586657
  596686
  600208
  602067
  609634
  611282
  622677
  625360
  628469
  629631
  636873
  640319
  646066
  650070
  654286
  658943
  659262
  660336
  664417
  666067
  672820
  675613
  677903
  677919
  680259
  683420
  690703
  701427
  703968
  705788
  706211
  707149
  708747
  710261
  712846
  715907
  716796
  717122
  717159
  720015
  721264
  724795
  725641
  725779
  726920
  728060
  730360
  736444
  739521
  740037
  742202
  742312
  742939
  744378
  746293
  750864
  752509
  759008
  760874
  762675
  765341
  765717
  766711
  767377
  769287
  770998
  771986
  772863
  779317
  779513
  780583
  781486
  784299
  786477
  787927
  790806
  791475
  791530
  794337
  794877
  795504
  797438
  797840
  799508
  799549
  799742
  800050
  801547
  801574
  802806
  808084
  808855
  809874
  817940
  819779
  819948
  820378
  820540
]
1.99 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "doggystyle sex"
]
1.83 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "doggystyle секс"
]
1.59 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.33 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "doggystyle секс"
]

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.