Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
206.22 ms
(53.50%)
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
  129902
  190870
  346979
  348262
  383719
  387026
  388973
  391521
  419777
  420886
  430876
  449872
  452006
  452594
  453456
  454196
  455034
  455175
  455910
  460032
  461060
  465654
  466150
  472310
  476086
  476158
  476771
  479145
  485089
  485365
  486986
  490905
  490927
  491996
  499816
  501205
  501505
  506002
  512046
  512344
  512494
  513214
  515588
  515602
  515617
  515679
  517952
  519438
  526222
  532983
  542193
  544260
  544794
  546712
  546928
  549528
  550686
  552021
  555170
  563168
  567321
  568483
  569918
  578155
  586655
  587155
  588631
  590492
  592413
  595446
  600851
  600858
  604307
  605221
  605990
  607202
  607269
  612403
  617680
  643188
  646447
  647611
  666353
  666830
  667523
  667694
  693331
  704068
  716879
  720473
  721773
  727653
  728295
  734611
  742695
  745461
  752950
  760818
  790951
  796243
  801416
  804530
  804825
  805354
  810734
  811220
  812912
  814140
  814332
  814760
  815063
  815138
  815152
  815290
  815413
  815799
  815956
  816085
  820173
  823644
]
153.32 ms
(39.78%)
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
  129902
  190870
  346979
  348262
  383719
  387026
  388973
  391521
  419777
  420886
  430876
  449872
  452006
  452594
  453456
  454196
  455034
  455175
  455910
  460032
  461060
  465654
  466150
  472310
  476086
  476158
  476771
  479145
  485089
  485365
  486986
  490905
  490927
  491996
  499816
  501205
  501505
  506002
  512046
  512344
  512494
  513214
  515588
  515602
  515617
  515679
  517952
  519438
  526222
  532983
  542193
  544260
  544794
  546712
  546928
  549528
  550686
  552021
  555170
  563168
  567321
  568483
  569918
  578155
  586655
  587155
  588631
  590492
  592413
  595446
  600851
  600858
  604307
  605221
  605990
  607202
  607269
  612403
  617680
  643188
  646447
  647611
  666353
  666830
  667523
  667694
  693331
  704068
  716879
  720473
  721773
  727653
  728295
  734611
  742695
  745461
  752950
  760818
  790951
  796243
  801416
  804530
  804825
  805354
  810734
  811220
  812912
  814140
  814332
  814760
  815063
  815138
  815152
  815290
  815413
  815799
  815956
  816085
  820173
  823644
]
18.43 ms
(4.78%)
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
  452594
  465654
  383719
  348262
  454196
  466150
  512494
  515679
  519438
  526222
  515588
  513214
  666353
  600851
  592413
  455034
  479145
  430876
  491996
  567321
  388973
  816085
  815799
  815956
  815152
  823644
  814332
  815138
  460032
  512046
  544794
  563168
  555170
  568483
  667523
  667694
  647611
  666830
  587155
  595446
  600858
  605990
  643188
  604307
  607269
  790951
  805354
  727653
  752950
  796243
  801416
  804530
  804825
  812912
  728295
  734611
  745461
  760818
  742695
  612403
  617680
  716879
  810734
  476086
  485365
  485089
  490905
  815290
  472310
  578155
  546712
  811220
  449872
  391521
  387026
  452006
  501205
  501505
  512344
  517952
  486986
  490927
  515617
  542193
  455910
  515602
  544260
  499816
  453456
  590492
  607202
  820173
  814760
  815063
  815413
  532983
  461060
  549528
  646447
  588631
  419777
  420886
  129902
  190870
  346979
  814140
  476771
  476158
  455175
  506002
  569918
  546928
  693331
  704068
  720473
  721773
  550686
  552021
  605221
  586655
]
2.11 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "office stockings"
]
1.98 ms
(0.51%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(0.47%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секретарш чулк нижн бел"
]
1.55 ms
(0.40%)
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.