Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.96 ms
(84.50%)
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
  172164
  197300
  310190
  383891
  389969
  390669
  392159
  392480
  393987
  395926
  398462
  407746
  408334
  410015
  433388
  437233
  441452
  443975
  444177
  448670
  453214
  454957
  455123
  456794
  457581
  459024
  459078
  459959
  460572
  466935
  467702
  467858
  478387
  478406
  478543
  483210
  483642
  485027
  486635
  487753
  492088
  493185
  495244
  502994
  506207
  506866
  507860
  518152
  519840
  525232
  525714
  525786
  526454
  535445
  542297
  543296
  543696
  546392
  546893
  549726
  549732
  550279
  551534
  551588
  551810
  564967
  567901
  569373
  569993
  570936
  577122
  591741
  599189
  603043
  606530
  619490
  631684
  633541
  646052
  651810
  662387
  662454
  666457
  668768
  679863
  684706
  687447
  690703
  701545
  705073
  709447
  717367
  720645
  724139
  725022
  725217
  727844
  733480
  734097
  739557
  741567
  742642
  748605
  755111
  756421
  760400
  760761
  761456
  769474
  779419
  793797
  800303
  800906
  803621
  804560
  806245
  808223
  813559
  817147
  824370
]
11.63 ms
(7.56%)
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
  800303
  705073
  603043
  813559
  808223
  806245
  606530
  407746
  755111
  535445
  492088
  760400
  507860
  310190
  756421
  395926
  550279
  549732
  577122
  668768
  793797
  502994
  172164
  687447
  760761
  393987
  734097
  619490
  817147
  725022
  551534
  542297
  487753
  483642
  717367
  519840
  392480
  739557
  518152
  725217
  543296
  742642
  769474
  779419
  525714
  701545
  493185
  383891
  761456
  525232
  569993
  197300
  454957
  631684
  466935
  467858
  483210
  804560
  410015
  662387
  662454
  720645
  478543
  727844
  448670
  459959
  733480
  408334
  564967
  800906
  478387
  506207
  684706
  591741
  543696
  599189
  551810
  546392
  690703
  633541
  457581
  485027
  443975
  453214
  666457
  679863
  392159
  437233
  389969
  433388
  398462
  803621
  724139
  567901
  526454
  748605
  506866
  459078
  525786
  646052
  546893
  741567
  456794
  459024
  709447
  486635
  390669
  551588
  441452
  455123
  495244
  460572
  478406
  570936
  651810
  549726
  569373
  467702
  444177
  824370
]
3.41 ms
(2.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "домашнее сисястые рак…"
]
3.28 ms
(2.13%)
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
  172164
  197300
  310190
  383891
  389969
  390669
  392159
  392480
  393987
  395926
  398462
  407746
  408334
  410015
  433388
  437233
  441452
  443975
  444177
  448670
  453214
  454957
  455123
  456794
  457581
  459024
  459078
  459959
  460572
  466935
  467702
  467858
  478387
  478406
  478543
  483210
  483642
  485027
  486635
  487753
  492088
  493185
  495244
  502994
  506207
  506866
  507860
  518152
  519840
  525232
  525714
  525786
  526454
  535445
  542297
  543296
  543696
  546392
  546893
  549726
  549732
  550279
  551534
  551588
  551810
  564967
  567901
  569373
  569993
  570936
  577122
  591741
  599189
  603043
  606530
  619490
  631684
  633541
  646052
  651810
  662387
  662454
  666457
  668768
  679863
  684706
  687447
  690703
  701545
  705073
  709447
  717367
  720645
  724139
  725022
  725217
  727844
  733480
  734097
  739557
  741567
  742642
  748605
  755111
  756421
  760400
  760761
  761456
  769474
  779419
  793797
  800303
  800906
  803621
  804560
  806245
  808223
  813559
  817147
  824370
]
1.99 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск большие сиськ рак"
]
1.82 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск большие сиськ рак"
]
1.69 ms
(1.10%)
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.