Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.17 ms
(85.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
  177447
  229704
  271280
  382488
  383139
  383635
  386203
  386678
  387033
  395530
  395656
  396041
  396279
  397269
  401552
  403061
  412287
  414729
  415016
  416476
  426451
  429123
  437946
  438959
  443642
  444619
  445048
  445554
  445582
  446697
  449060
  452104
  453325
  453565
  457961
  460435
  460620
  462914
  465073
  475283
  475482
  479781
  479784
  481695
  486721
  497653
  505061
  509729
  516848
  517741
  520256
  535045
  536640
  538300
  539064
  545198
  550089
  554192
  561435
  565738
  571053
  572858
  580497
  593966
  601032
  607494
  612229
  625182
  646152
  650179
  669574
  670239
  671396
  676388
  715352
  727887
  729861
  752454
  758492
  773508
  775237
  776161
  783784
  786921
  793376
  797375
  797459
  798391
  800708
  801342
  803295
  809283
  810197
  810241
  810903
  811028
  811052
  813112
  814137
  814234
  814965
  817246
  817760
  820072
  821288
  821621
  821972
  822211
  822617
  822622
  823502
  824254
  824472
  824740
  824918
  825412
  826211
  827839
]
12.25 ms
(7.69%)
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
  387033
  817760
  452104
  823502
  824918
  445048
  475482
  401552
  453565
  445582
  395656
  396041
  444619
  271280
  814234
  783784
  438959
  814137
  509729
  671396
  797375
  811052
  445554
  462914
  520256
  416476
  497653
  822211
  517741
  539064
  561435
  572858
  545198
  715352
  607494
  775237
  801342
  727887
  803295
  810197
  395530
  449060
  670239
  426451
  437946
  460435
  538300
  814965
  822402
  535045
  822617
  811028
  821972
  826211
  824254
  821621
  824472
  824740
  825412
  827839
  798391
  786921
  793376
  414729
  773508
  396279
  453325
  554192
  386678
  536640
  669574
  479784
  505061
  676388
  625182
  797459
  481695
  565738
  593966
  412287
  446697
  465073
  580497
  475283
  443642
  397269
  479781
  516848
  229704
  382488
  383139
  820072
  177447
  817246
  822622
  810903
  729861
  403061
  386203
  821288
  415016
  460620
  571053
  650179
  429123
  383635
  550089
  646152
  813112
  457961
  486721
  540323
  601032
  612229
  776161
  800708
  809283
  810241
  752454
  758492
]
3.28 ms
(2.06%)
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
  177447
  229704
  271280
  382488
  383139
  383635
  386203
  386678
  387033
  395530
  395656
  396041
  396279
  397269
  401552
  403061
  412287
  414729
  415016
  416476
  426451
  429123
  437946
  438959
  443642
  444619
  445048
  445554
  445582
  446697
  449060
  452104
  453325
  453565
  457961
  460435
  460620
  462914
  465073
  475283
  475482
  479781
  479784
  481695
  486721
  497653
  505061
  509729
  516848
  517741
  520256
  535045
  536640
  538300
  539064
  545198
  550089
  554192
  561435
  565738
  571053
  572858
  580497
  593966
  601032
  607494
  612229
  625182
  646152
  650179
  669574
  670239
  671396
  676388
  715352
  727887
  729861
  752454
  758492
  773508
  775237
  776161
  783784
  786921
  793376
  797375
  797459
  798391
  800708
  801342
  803295
  809283
  810197
  810241
  810903
  811028
  811052
  813112
  814137
  814234
  814965
  817246
  817760
  820072
  821288
  821621
  821972
  822211
  822617
  822622
  823502
  824254
  824472
  824740
  824918
  825412
  826211
  827839
]
2.12 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "latina blowjob"
]
1.92 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "латинская минет оральн секс"
]
1.86 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(1.04%)
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.