Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.54 ms
(85.61%)
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
  6920
  58287
  144181
  307339
  382475
  383681
  385010
  395612
  395732
  395803
  396092
  396293
  396449
  396657
  396788
  397780
  398891
  399598
  401037
  402557
  403132
  403603
  404230
  406841
  408898
  411532
  412066
  413738
  417609
  418027
  418884
  420788
  425218
  426129
  427336
  428807
  437322
  438816
  441169
  442423
  442962
  444117
  448598
  454469
  456044
  457989
  458296
  458565
  458902
  459466
  460620
  463120
  463565
  465138
  465700
  466568
  467168
  467649
  467838
  469257
  469956
  471386
  472629
  473065
  473358
  477227
  477411
  480353
  481094
  486752
  490211
  491443
  494378
  495888
  498500
  511550
  515461
  520228
  528451
  537026
  540021
  549999
  550042
  553866
  555835
  560748
  561720
  563700
  564631
  565062
  568367
  570224
  570406
  570796
  573924
  576289
  576363
  577847
  578456
  580822
  582780
  585054
  589112
  597241
  599145
  603301
  620051
  636063
  641074
  696485
  702512
  712930
  780128
  784555
  788855
  790896
  791033
  800001
  809410
  811960
]
17.16 ms
(8.87%)
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
  385010
  383681
  144181
  395732
  307339
  58287
  396092
  396293
  396657
  397780
  398891
  403603
  418027
  428807
  444117
  426129
  441169
  417609
  442423
  585054
  448598
  454469
  457989
  458296
  472629
  456044
  458565
  463565
  466568
  467168
  486752
  458902
  473065
  480353
  540021
  515461
  520228
  495888
  511550
  463120
  467649
  467838
  491443
  549999
  563700
  580822
  568367
  570224
  576363
  582780
  555835
  560748
  565062
  573924
  577847
  702512
  696485
  712930
  550042
  553866
  561720
  564631
  570406
  570796
  576289
  578456
  589112
  636063
  597241
  620051
  599145
  603301
  780128
  788855
  811960
  784555
  800001
  641074
  790896
  791033
  809410
  382475
  396449
  402557
  403132
  413738
  481094
  6920
  395803
  399598
  404230
  418884
  427336
  442962
  459466
  460620
  465138
  469257
  477411
  396788
  408898
  412066
  437322
  471386
  395612
  401037
  406841
  420788
  425218
  465700
  469956
  473358
  477227
  411532
  438816
  528451
  537026
  490211
  494378
  498500
]
3.44 ms
(1.78%)
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
  6920
  58287
  144181
  307339
  382475
  383681
  385010
  395612
  395732
  395803
  396092
  396293
  396449
  396657
  396788
  397780
  398891
  399598
  401037
  402557
  403132
  403603
  404230
  406841
  408898
  411532
  412066
  413738
  417609
  418027
  418884
  420788
  425218
  426129
  427336
  428807
  437322
  438816
  441169
  442423
  442962
  444117
  448598
  454469
  456044
  457989
  458296
  458565
  458902
  459466
  460620
  463120
  463565
  465138
  465700
  466568
  467168
  467649
  467838
  469257
  469956
  471386
  472629
  473065
  473358
  477227
  477411
  480353
  481094
  486752
  490211
  491443
  494378
  495888
  498500
  511550
  515461
  520228
  528451
  537026
  540021
  549999
  550042
  553866
  555835
  560748
  561720
  563700
  564631
  565062
  568367
  570224
  570406
  570796
  573924
  576289
  576363
  577847
  578456
  580822
  582780
  585054
  589112
  597241
  599145
  603301
  620051
  636063
  641074
  696485
  702512
  712930
  780128
  784555
  788855
  790896
  791033
  800001
  809410
  811960
]
2.02 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "xxx спортивная"
]
1.95 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "xxx sport"
]
1.68 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "xxx спортивная"
]
1.59 ms
(0.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.