Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
166.74 ms
(85.81%)
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
  152508
  411730
  413170
  413714
  413716
  423516
  424419
  429483
  451712
  453134
  453999
  454184
  460980
  462210
  462654
  469903
  480481
  485758
  486384
  492757
  504886
  509417
  512031
  518152
  518843
  520293
  524488
  525720
  526672
  535321
  535898
  540370
  544754
  551031
  554524
  558005
  563648
  566231
  566588
  569388
  569728
  575610
  584728
  589824
  593098
  594853
  596322
  601022
  603340
  609045
  618302
  635786
  638302
  651794
  663921
  667264
  669201
  675956
  677270
  678221
  684977
  695151
  696316
  709309
  716274
  718834
  722536
  726954
  728172
  730847
  733545
  734693
  734725
  734837
  735460
  738266
  738901
  740545
  740965
  742714
  747607
  750554
  755411
  757253
  761385
  764507
  764524
  767913
  768884
  769158
  769562
  771211
  771867
  774421
  775895
  781704
  781743
  784143
  784297
  786179
  786575
  788791
  793811
  795409
  795867
  795915
  797240
  797262
  798573
  799503
  801408
  801896
  803645
  804813
  807002
  808238
  810037
  813801
  814616
  828708
]
18.02 ms
(9.27%)
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
  675956
  678221
  695151
  718834
  651794
  663921
  667264
  669201
  677270
  684977
  696316
  716274
  722536
  544754
  569728
  596322
  609045
  635786
  638302
  594853
  601022
  603340
  593098
  618302
  589824
  781704
  795867
  795915
  801896
  775895
  781743
  795409
  799503
  803645
  808238
  730847
  734693
  738266
  747607
  750554
  757253
  761385
  764524
  769158
  786179
  786575
  797240
  797262
  807002
  810037
  728172
  740545
  767913
  771211
  733545
  734837
  726954
  735460
  768884
  734725
  738901
  740965
  742714
  755411
  764507
  769562
  771867
  709309
  784143
  784297
  788791
  793811
  798573
  801408
  804813
  152508
  451712
  413714
  424419
  469903
  504886
  828708
  413716
  423516
  429483
  411730
  413170
  774421
  813801
  814616
  486384
  453134
  453999
  454184
  460980
  480481
  485758
  492757
  462210
  525720
  540370
  512031
  518843
  520293
  535898
  524488
  526672
  535321
  509417
  518152
  462654
  551031
  554524
  563648
  575610
  584728
  558005
  569388
  566231
  566588
]
2.31 ms
(1.19%)
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
  152508
  411730
  413170
  413714
  413716
  423516
  424419
  429483
  451712
  453134
  453999
  454184
  460980
  462210
  462654
  469903
  480481
  485758
  486384
  492757
  504886
  509417
  512031
  518152
  518843
  520293
  524488
  525720
  526672
  535321
  535898
  540370
  544754
  551031
  554524
  558005
  563648
  566231
  566588
  569388
  569728
  575610
  584728
  589824
  593098
  594853
  596322
  601022
  603340
  609045
  618302
  635786
  638302
  651794
  663921
  667264
  669201
  675956
  677270
  678221
  684977
  695151
  696316
  709309
  716274
  718834
  722536
  726954
  728172
  730847
  733545
  734693
  734725
  734837
  735460
  738266
  738901
  740545
  740965
  742714
  747607
  750554
  755411
  757253
  761385
  764507
  764524
  767913
  768884
  769158
  769562
  771211
  771867
  774421
  775895
  781704
  781743
  784143
  784297
  786179
  786575
  788791
  793811
  795409
  795867
  795915
  797240
  797262
  798573
  799503
  801408
  801896
  803645
  804813
  807002
  808238
  810037
  813801
  814616
  828708
]
2.05 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "блондинка с висячими %…"
]
1.81 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "беловолосая обвисшая"
]
1.76 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(0.84%)
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.