Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.52 ms
(83.70%)
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
  187349
  233608
  358365
  382699
  383823
  390272
  391944
  391978
  397880
  398964
  400483
  401001
  401916
  407903
  411327
  419525
  421885
  422196
  422243
  423934
  427088
  428133
  428202
  433361
  434252
  439634
  439686
  439752
  440593
  442118
  443777
  445201
  454245
  454499
  454548
  455120
  455440
  462084
  462100
  463976
  464858
  465552
  466011
  466226
  466893
  470768
  470944
  473400
  475238
  476282
  477715
  479299
  482483
  484361
  484365
  484406
  485741
  485946
  487753
  488541
  488980
  489381
  490427
  493274
  493974
  495228
  495517
  495878
  498422
  500883
  503201
  509251
  510334
  513451
  514436
  518614
  519133
  519154
  519342
  519480
  522237
  525307
  526499
  526579
  535605
  536457
  543574
  543714
  545535
  550420
  556459
  557244
  562168
  563001
  563010
  563143
  563442
  567959
  605409
  609194
  628649
  639156
  641807
  660546
  663429
  714865
  735945
  741564
  742405
  745357
  807275
  825391
  825881
  826478
  826484
  826585
  826586
  826929
  826932
  827013
]
18.82 ms
(10.26%)
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
  518614
  550420
  482483
  454548
  526499
  383823
  422243
  427088
  421885
  439752
  419525
  462084
  477715
  433361
  495228
  485741
  390272
  735945
  545535
  609194
  233608
  514436
  476282
  487753
  563001
  556459
  562168
  563442
  563010
  187349
  423934
  397880
  422196
  536457
  488980
  500883
  503201
  488541
  490427
  493274
  535605
  714865
  401001
  465552
  454245
  605409
  473400
  391944
  464858
  663429
  641807
  400483
  407903
  509251
  510334
  493974
  498422
  519133
  543574
  807275
  391978
  455120
  525307
  563143
  628649
  466893
  470768
  398964
  434252
  463976
  479299
  522237
  526579
  470944
  401916
  495517
  741564
  745357
  439686
  484361
  826478
  826484
  826586
  827013
  826585
  639156
  442118
  440593
  443777
  513451
  825391
  825881
  826929
  826932
  742405
  660546
  454499
  462100
  557244
  455440
  466226
  475238
  428133
  519480
  519342
  485946
  489381
  495878
  519154
  484406
  445201
  466011
  411327
  484365
  428202
  567959
  543714
  382699
  358365
  439634
]
3.55 ms
(1.93%)
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
  187349
  233608
  358365
  382699
  383823
  390272
  391944
  391978
  397880
  398964
  400483
  401001
  401916
  407903
  411327
  419525
  421885
  422196
  422243
  423934
  427088
  428133
  428202
  433361
  434252
  439634
  439686
  439752
  440593
  442118
  443777
  445201
  454245
  454499
  454548
  455120
  455440
  462084
  462100
  463976
  464858
  465552
  466011
  466226
  466893
  470768
  470944
  473400
  475238
  476282
  477715
  479299
  482483
  484361
  484365
  484406
  485741
  485946
  487753
  488541
  488980
  489381
  490427
  493274
  493974
  495228
  495517
  495878
  498422
  500883
  503201
  509251
  510334
  513451
  514436
  518614
  519133
  519154
  519342
  519480
  522237
  525307
  526499
  526579
  535605
  536457
  543574
  543714
  545535
  550420
  556459
  557244
  562168
  563001
  563010
  563143
  563442
  567959
  605409
  609194
  628649
  639156
  641807
  660546
  663429
  714865
  735945
  741564
  742405
  745357
  807275
  825391
  825881
  826478
  826484
  826585
  826586
  826929
  826932
  827013
]
2.22 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "пышки русское ебля"
]
2.00 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "полная русск секс"
]
1.63 ms
(0.89%)
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.