Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.78 ms
(80.14%)
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
  383722
  388642
  398467
  412541
  421817
  427897
  437175
  439808
  444888
  446908
  448971
  450910
  452677
  454972
  456328
  458788
  461730
  461795
  467053
  473177
  474125
  484119
  484225
  485706
  488556
  494837
  499072
  500701
  505106
  505796
  509740
  510345
  510575
  513575
  515699
  516325
  516632
  517343
  517736
  517824
  518118
  518501
  519203
  521138
  522705
  523436
  524310
  525169
  526280
  526316
  527519
  528864
  528911
  529106
  529111
  529126
  536414
  537148
  543404
  543554
  545692
  547523
  548232
  552296
  552414
  554415
  554863
  559348
  559734
  561481
  563042
  565738
  566939
  567112
  569194
  569312
  569442
  571349
  572211
  575784
  577332
  578723
  581855
  582053
  582680
  585756
  588988
  591694
  598246
  598602
  599061
  599277
  601456
  601852
  606162
  606836
  609096
  613202
  614565
  618759
  621305
  624090
  624139
  636559
  659407
  659451
  663935
  665479
  667876
  678778
  692253
  714470
  720610
  731767
  780710
  784669
  788229
  804940
  808160
  814621
]
16.60 ms
(9.31%)
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
  499072
  452677
  517736
  524310
  474125
  569194
  582053
  609096
  458788
  678778
  621305
  636559
  510345
  569442
  618759
  505796
  528911
  523436
  585756
  485706
  484225
  601456
  547523
  446908
  517824
  529126
  543404
  554863
  559734
  591694
  598602
  421817
  444888
  613202
  516632
  510575
  554415
  528864
  516325
  526280
  563042
  814621
  663935
  667876
  804940
  731767
  780710
  581855
  383722
  714470
  788229
  808160
  784669
  513575
  398467
  565738
  454972
  526316
  572211
  545692
  566939
  659451
  588988
  598246
  461795
  488556
  529111
  548232
  518118
  582680
  578723
  388642
  461730
  519203
  552296
  577332
  624090
  439808
  614565
  659407
  536414
  599061
  517343
  500701
  561481
  601852
  521138
  509740
  412541
  529106
  505106
  527519
  473177
  543554
  567112
  575784
  606162
  624139
  456328
  484119
  525169
  494837
  522705
  427897
  518501
  569312
  606836
  448971
  450910
  437175
  552414
  571349
  515699
  537148
  559348
  665479
  692253
  720610
  599277
  467053
]
4.24 ms
(2.38%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "бабушк куннилингус оральн секс стринг нижн бел"
]
4.23 ms
(2.38%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
4.09 ms
(2.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "старушки куни стринги…"
]
3.78 ms
(2.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "бабушк куннилингус оральн секс стринг нижн бел"
]
2.45 ms
(1.38%)
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
  383722
  388642
  398467
  412541
  421817
  427897
  437175
  439808
  444888
  446908
  448971
  450910
  452677
  454972
  456328
  458788
  461730
  461795
  467053
  473177
  474125
  484119
  484225
  485706
  488556
  494837
  499072
  500701
  505106
  505796
  509740
  510345
  510575
  513575
  515699
  516325
  516632
  517343
  517736
  517824
  518118
  518501
  519203
  521138
  522705
  523436
  524310
  525169
  526280
  526316
  527519
  528864
  528911
  529106
  529111
  529126
  536414
  537148
  543404
  543554
  545692
  547523
  548232
  552296
  552414
  554415
  554863
  559348
  559734
  561481
  563042
  565738
  566939
  567112
  569194
  569312
  569442
  571349
  572211
  575784
  577332
  578723
  581855
  582053
  582680
  585756
  588988
  591694
  598246
  598602
  599061
  599277
  601456
  601852
  606162
  606836
  609096
  613202
  614565
  618759
  621305
  624090
  624139
  636559
  659407
  659451
  663935
  665479
  667876
  678778
  692253
  714470
  720610
  731767
  780710
  784669
  788229
  804940
  808160
  814621
]

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.