Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.93 ms
(84.59%)
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
  12423
  17058
  21488
  114712
  282558
  358438
  382818
  388746
  389943
  393061
  400556
  403979
  406853
  411778
  420510
  424809
  427851
  433097
  445539
  446129
  448830
  473609
  500331
  500798
  514801
  515240
  523535
  532428
  556851
  559108
  578527
  590857
  597841
  600425
  602859
  603239
  615538
  654624
  660863
  675241
  675960
  676404
  678313
  678561
  682914
  695940
  701463
  711337
  718655
  720819
  721569
  721796
  721843
  722822
  723481
  723527
  723603
  725312
  729328
  735418
  742158
  746100
  747017
  751495
  751618
  758456
  759548
  767957
  770217
  770520
  772970
  773441
  776307
  788770
  789872
  790063
  792337
  792822
  796555
  797654
  799599
  803343
  803677
  804455
  804771
  805276
  805537
  805989
  806227
  806346
  807376
  809723
  812151
  812735
  814936
  814942
  815248
  815337
  815345
  815395
  815505
  815534
  815591
  815826
  816058
  816068
  816562
  818169
  818273
  818277
  818282
  818325
  818382
  818459
  820047
  820387
  821612
  822222
  822986
  823420
]
15.15 ms
(9.79%)
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
  792337
  803677
  701463
  812735
  17058
  406853
  818459
  815505
  695940
  660863
  799599
  772970
  759548
  747017
  590857
  816058
  815345
  515240
  805537
  807376
  806227
  815395
  711337
  751495
  722822
  514801
  420510
  114712
  12423
  282558
  358438
  446129
  427851
  559108
  578527
  500331
  556851
  597841
  448830
  445539
  500798
  523535
  433097
  473609
  600425
  682914
  603239
  790063
  803343
  388746
  382818
  818169
  815826
  751618
  721569
  393061
  814936
  654624
  675960
  676404
  403979
  820047
  818325
  820387
  816068
  532428
  678313
  721796
  723481
  718655
  615538
  602859
  792822
  773441
  742158
  767957
  725312
  746100
  776307
  400556
  424809
  804771
  389943
  815534
  818277
  822222
  723527
  723603
  815337
  816562
  818382
  823420
  678561
  720819
  805276
  805989
  788770
  796555
  806346
  812151
  758456
  789872
  804455
  729328
  735418
  770217
  770520
  721843
  797654
  809723
  675241
  21488
  411778
  815248
  815591
  821612
  814942
  818282
  822986
  818273
]
2.51 ms
(1.62%)
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
  12423
  17058
  21488
  114712
  282558
  358438
  382818
  388746
  389943
  393061
  400556
  403979
  406853
  411778
  420510
  424809
  427851
  433097
  445539
  446129
  448830
  473609
  500331
  500798
  514801
  515240
  523535
  532428
  556851
  559108
  578527
  590857
  597841
  600425
  602859
  603239
  615538
  654624
  660863
  675241
  675960
  676404
  678313
  678561
  682914
  695940
  701463
  711337
  718655
  720819
  721569
  721796
  721843
  722822
  723481
  723527
  723603
  725312
  729328
  735418
  742158
  746100
  747017
  751495
  751618
  758456
  759548
  767957
  770217
  770520
  772970
  773441
  776307
  788770
  789872
  790063
  792337
  792822
  796555
  797654
  799599
  803343
  803677
  804455
  804771
  805276
  805537
  805989
  806227
  806346
  807376
  809723
  812151
  812735
  814936
  814942
  815248
  815337
  815345
  815395
  815505
  815534
  815591
  815826
  816058
  816068
  816562
  818169
  818273
  818277
  818282
  818325
  818382
  818459
  820047
  820387
  821612
  822222
  822986
  823420
]
1.73 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "жмж римминг анилингус"
]
1.53 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жмж секс втро анилингус анилингус"
]
1.50 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жмж секс втро анилингус анилингус"
]
1.44 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.