Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.66 ms
(86.62%)
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
  96530
  389726
  395401
  395499
  396557
  397349
  403891
  408449
  413783
  415896
  417562
  423349
  424314
  424788
  426478
  427912
  431476
  434779
  435244
  440890
  443599
  450570
  454322
  454927
  459189
  461115
  461144
  462995
  463663
  464211
  465780
  466490
  469407
  471437
  472785
  472935
  474421
  477478
  481726
  483320
  488618
  492529
  493169
  497463
  498891
  499348
  501734
  503739
  508121
  511637
  512478
  513156
  513545
  514677
  516550
  516848
  518328
  518953
  519200
  519479
  519621
  520427
  522498
  525547
  526413
  527054
  527453
  528877
  545645
  546532
  546908
  550463
  550703
  555736
  561488
  567474
  568566
  569408
  569921
  571843
  578057
  584192
  585250
  589196
  589711
  589723
  592914
  596898
  596987
  597738
  598980
  602475
  603144
  609214
  612490
  615709
  616629
  621267
  621973
  625594
  626868
  629129
  638688
  642657
  647302
  652358
  654898
  688188
  692767
  729999
  751600
  771969
  788533
  797375
  797437
  805152
  805963
  807914
  809346
  814255
]
15.12 ms
(8.36%)
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
  626868
  616629
  638688
  805152
  751600
  788533
  403891
  525547
  493169
  546908
  584192
  597738
  609214
  426478
  443599
  519479
  550463
  596898
  809346
  472785
  499348
  488618
  498891
  503739
  527453
  555736
  424314
  518328
  527054
  596987
  465780
  513545
  481726
  469407
  461144
  519200
  472935
  431476
  522498
  508121
  413783
  435244
  462995
  471437
  612490
  516848
  440890
  585250
  797375
  477478
  569921
  642657
  514677
  561488
  415896
  546532
  568566
  647302
  654898
  688188
  578057
  589711
  603144
  589196
  729999
  629129
  395499
  464211
  518953
  692767
  389726
  474421
  567474
  450570
  434779
  598980
  589723
  625594
  513156
  512478
  571843
  807914
  459189
  395401
  427912
  814255
  497463
  652358
  550703
  592914
  621267
  602475
  615709
  805963
  771969
  797437
  408449
  454322
  511637
  397349
  463663
  528877
  520427
  454927
  466490
  483320
  501734
  423349
  569408
  545645
  621973
  396557
  526413
  519621
  492529
  516550
  96530
  424788
  417562
  461115
]
2.77 ms
(1.53%)
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
  96530
  389726
  395401
  395499
  396557
  397349
  403891
  408449
  413783
  415896
  417562
  423349
  424314
  424788
  426478
  427912
  431476
  434779
  435244
  440890
  443599
  450570
  454322
  454927
  459189
  461115
  461144
  462995
  463663
  464211
  465780
  466490
  469407
  471437
  472785
  472935
  474421
  477478
  481726
  483320
  488618
  492529
  493169
  497463
  498891
  499348
  501734
  503739
  508121
  511637
  512478
  513156
  513545
  514677
  516550
  516848
  518328
  518953
  519200
  519479
  519621
  520427
  522498
  525547
  526413
  527054
  527453
  528877
  545645
  546532
  546908
  550463
  550703
  555736
  561488
  567474
  568566
  569408
  569921
  571843
  578057
  584192
  585250
  589196
  589711
  589723
  592914
  596898
  596987
  597738
  598980
  602475
  603144
  609214
  612490
  615709
  616629
  621267
  621973
  625594
  626868
  629129
  638688
  642657
  647302
  652358
  654898
  688188
  692767
  729999
  751600
  771969
  788533
  797375
  797437
  805152
  805963
  807914
  809346
  814255
]
1.71 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие сиськ hotel"
]
1.63 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big tits hotel"
]
1.57 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.41 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие сиськ hotel"
]

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.