Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.66 ms
(82.74%)
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
  422291
  422524
  422557
  422618
  423264
  429174
  444386
  444768
  445057
  446133
  446143
  449911
  454151
  462781
  464355
  464880
  466677
  472223
  476157
  477467
  479825
  482522
  482818
  485479
  489842
  491700
  492394
  496993
  506850
  509487
  519682
  522117
  523446
  523987
  524227
  529048
  531429
  531430
  533814
  547061
  551892
  553128
  554068
  554302
  556329
  566029
  566063
  567360
  575500
  577515
  578360
  580185
  580776
  582548
  582597
  583679
  586498
  587202
  590934
  593354
  593418
  594014
  595925
  596566
  597226
  598438
  600559
  602044
  603773
  605727
  609052
  616000
  618916
  620011
  620103
  623598
  624273
  624276
  630528
  653548
  654392
  654423
  665296
  672588
  677311
  700659
  705667
  705717
  709636
  709732
  715138
  716528
  717610
  717708
  717845
  719102
  720802
  720819
  721704
  722199
  722462
  724509
  725115
  727696
  727753
  732423
  736631
  740526
  744511
  745322
  747439
  747984
  751722
  752132
  756181
  757442
  758193
  761474
  793436
  810242
]
18.04 ms
(11.60%)
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
  422618
  423264
  429174
  422524
  445057
  422291
  422557
  444386
  444768
  482818
  466677
  477467
  479825
  489842
  492394
  454151
  476157
  446133
  446143
  449911
  464355
  485479
  496993
  523987
  506850
  519682
  522117
  529048
  523446
  531429
  531430
  509487
  524227
  533814
  462781
  464880
  472223
  482522
  491700
  577515
  580776
  582548
  547061
  566063
  551892
  554068
  556329
  567360
  578360
  580185
  653548
  654392
  700659
  709732
  716528
  719102
  654423
  665296
  672588
  705717
  709636
  677311
  717610
  717845
  720802
  720819
  722199
  722462
  553128
  554302
  566029
  575500
  582597
  583679
  586498
  595925
  605727
  587202
  590934
  593354
  598438
  600559
  618916
  593418
  594014
  597226
  616000
  620103
  624273
  596566
  603773
  609052
  620011
  624276
  630528
  793436
  740526
  752132
  810242
  724509
  725115
  727696
  747439
  747984
  756181
  757442
  736631
  758193
  727753
  732423
  744511
  751722
  745322
  761474
  602044
  623598
  705667
  715138
  717708
  721704
]
2.35 ms
(1.51%)
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
  422291
  422524
  422557
  422618
  423264
  429174
  444386
  444768
  445057
  446133
  446143
  449911
  454151
  462781
  464355
  464880
  466677
  472223
  476157
  477467
  479825
  482522
  482818
  485479
  489842
  491700
  492394
  496993
  506850
  509487
  519682
  522117
  523446
  523987
  524227
  529048
  531429
  531430
  533814
  547061
  551892
  553128
  554068
  554302
  556329
  566029
  566063
  567360
  575500
  577515
  578360
  580185
  580776
  582548
  582597
  583679
  586498
  587202
  590934
  593354
  593418
  594014
  595925
  596566
  597226
  598438
  600559
  602044
  603773
  605727
  609052
  616000
  618916
  620011
  620103
  623598
  624273
  624276
  630528
  653548
  654392
  654423
  665296
  672588
  677311
  700659
  705667
  705717
  709636
  709732
  715138
  716528
  717610
  717708
  717845
  719102
  720802
  720819
  721704
  722199
  722462
  724509
  725115
  727696
  727753
  732423
  736631
  740526
  744511
  745322
  747439
  747984
  751722
  752132
  756181
  757442
  758193
  761474
  793436
  810242
]
2.07 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "man casting"
]
1.67 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мужчин кастинг"
]
1.23 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.