Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.87 ms
(84.25%)
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
  397510
  397643
  405990
  410606
  414048
  418528
  419972
  420067
  421103
  421298
  421346
  422519
  422543
  422584
  422649
  422656
  422925
  423007
  423025
  423414
  424615
  424715
  428728
  429627
  430474
  431670
  452221
  454685
  454704
  454741
  456700
  459233
  463752
  463753
  466395
  473019
  475799
  478025
  478431
  480801
  482237
  485303
  491354
  495866
  505369
  510577
  510587
  511264
  512172
  512205
  512214
  512224
  526789
  528772
  530685
  533295
  533388
  536525
  537732
  540186
  542904
  545508
  546041
  550745
  550759
  550761
  550763
  550979
  551941
  551991
  551995
  552006
  554298
  554416
  556393
  557228
  559910
  564794
  565469
  565473
  565986
  568535
  576496
  580272
  582863
  584675
  584685
  585967
  586639
  588228
  595945
  597275
  600627
  607742
  614730
  615923
  622601
  622645
  623519
  623604
  652121
  660763
  671835
  709688
  710893
  714118
  740804
  741134
  758728
  758882
  760481
  761468
  761566
  770812
  780715
  808756
  811384
  811784
  816842
  827068
]
17.05 ms
(9.40%)
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
  429627
  428728
  423414
  463752
  454685
  505369
  510577
  530685
  482237
  550745
  556393
  565986
  568535
  709688
  652121
  546041
  550761
  565473
  600627
  615923
  607742
  597275
  622645
  811384
  761468
  761566
  740804
  623519
  463753
  422925
  431670
  397643
  424715
  473019
  512172
  422656
  422519
  422584
  512205
  551941
  550979
  551995
  554416
  550763
  552006
  554298
  588228
  586639
  614730
  410606
  466395
  421346
  421103
  485303
  397510
  622601
  816842
  510587
  533295
  512214
  565469
  660763
  758728
  770812
  811784
  454704
  584675
  420067
  459233
  418528
  512224
  480801
  671835
  551991
  623604
  478025
  491354
  495866
  405990
  423007
  419972
  421298
  422649
  414048
  423025
  452221
  475799
  511264
  537732
  540186
  526789
  545508
  542904
  580272
  585967
  595945
  808756
  430474
  422543
  559910
  550759
  827068
  528772
  564794
  557228
  576496
  714118
  710893
  741134
  758882
  760481
  424615
  456700
  533388
  536525
  582863
  584685
  780715
  454741
  478431
]
3.69 ms
(2.03%)
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
  397510
  397643
  405990
  410606
  414048
  418528
  419972
  420067
  421103
  421298
  421346
  422519
  422543
  422584
  422649
  422656
  422925
  423007
  423025
  423414
  424615
  424715
  428728
  429627
  430474
  431670
  452221
  454685
  454704
  454741
  456700
  459233
  463752
  463753
  466395
  473019
  475799
  478025
  478431
  480801
  482237
  485303
  491354
  495866
  505369
  510577
  510587
  511264
  512172
  512205
  512214
  512224
  526789
  528772
  530685
  533295
  533388
  536525
  537732
  540186
  542904
  545508
  546041
  550745
  550759
  550761
  550763
  550979
  551941
  551991
  551995
  552006
  554298
  554416
  556393
  557228
  559910
  564794
  565469
  565473
  565986
  568535
  576496
  580272
  582863
  584675
  584685
  585967
  586639
  588228
  595945
  597275
  600627
  607742
  614730
  615923
  622601
  622645
  623519
  623604
  652121
  660763
  671835
  709688
  710893
  714118
  740804
  741134
  758728
  758882
  760481
  761468
  761566
  770812
  780715
  808756
  811384
  811784
  816842
  827068
]
2.44 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "toys asian"
]
1.84 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "toys азиатк"
]
1.78 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "toys азиатк"
]

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.