Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.70 ms
(76.06%)
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
  6669
  20180
  33379
  61051
  167756
  182526
  324183
  366053
  373852
  382158
  382246
  385755
  388642
  395597
  395999
  397643
  400788
  401344
  402266
  403896
  414048
  417161
  418009
  418188
  418528
  419910
  420252
  420613
  422511
  422513
  422550
  422561
  422572
  422592
  422649
  422657
  422879
  422901
  422909
  422923
  422925
  422926
  422929
  422958
  422960
  423042
  423245
  423263
  423283
  423414
  423418
  427358
  428801
  429379
  430468
  433152
  433279
  443550
  453019
  457259
  457882
  458094
  459237
  466691
  475443
  475450
  478025
  482621
  492732
  497382
  497444
  500686
  508962
  511249
  511264
  511271
  512680
  518011
  522198
  530685
  532941
  535434
  537201
  537932
  540187
  543919
  551991
  559160
  565344
  567837
  588228
  590280
  592380
  593606
  597275
  598344
  604319
  604652
  616612
  619441
  619445
  623510
  628422
  651620
  706946
  709688
  712158
  720306
  720872
  744704
  748661
  748685
  762296
  765703
  766607
  767286
  784161
  820459
  821892
  822535
]
30.45 ms
(17.32%)
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
  466691
  530685
  709688
  400788
  422561
  422572
  395999
  619445
  422901
  422511
  167756
  619441
  511249
  420252
  423414
  382246
  540187
  511264
  598344
  623510
  61051
  616612
  403896
  422657
  429379
  522198
  430468
  766607
  397643
  592380
  784161
  551991
  433152
  366053
  428801
  422909
  475450
  762296
  418528
  395597
  559160
  748685
  33379
  423042
  20180
  422649
  720306
  590280
  822535
  419910
  422592
  821892
  820459
  508962
  651620
  422923
  500686
  767286
  748661
  373852
  457882
  422550
  765703
  478025
  422513
  497444
  604652
  324183
  497382
  588228
  706946
  543919
  420613
  418009
  712158
  537932
  604319
  422926
  457259
  597275
  628422
  511271
  593606
  418188
  423263
  453019
  458094
  422925
  382158
  422958
  422879
  401344
  535434
  537201
  532941
  720872
  417161
  565344
  427358
  6669
  459237
  744704
  475443
  512680
  402266
  492732
  422929
  385755
  423418
  423245
  443550
  182526
  567837
  388642
  518011
  422960
  423283
  433279
  414048
  482621
]
4.78 ms
(2.72%)
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
  6669
  20180
  33379
  61051
  167756
  182526
  324183
  366053
  373852
  382158
  382246
  385755
  388642
  395597
  395999
  397643
  400788
  401344
  402266
  403896
  414048
  417161
  418009
  418188
  418528
  419910
  420252
  420613
  422511
  422513
  422550
  422561
  422572
  422592
  422649
  422657
  422879
  422901
  422909
  422923
  422925
  422926
  422929
  422958
  422960
  423042
  423245
  423263
  423283
  423414
  423418
  427358
  428801
  429379
  430468
  433152
  433279
  443550
  453019
  457259
  457882
  458094
  459237
  466691
  475443
  475450
  478025
  482621
  492732
  497382
  497444
  500686
  508962
  511249
  511264
  511271
  512680
  518011
  522198
  530685
  532941
  535434
  537201
  537932
  540187
  543919
  551991
  559160
  565344
  567837
  588228
  590280
  592380
  593606
  597275
  598344
  604319
  604652
  616612
  619441
  619445
  623510
  628422
  651620
  706946
  709688
  712158
  720306
  720872
  744704
  748661
  748685
  762296
  765703
  766607
  767286
  784161
  820459
  821892
  822535
]
2.13 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "азиатки анал секс"
]
1.65 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "азиатк анал секс"
]
1.56 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.