Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.65 ms
(81.24%)
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
  389821
  425749
  431521
  436490
  452782
  454868
  455179
  457658
  459947
  460119
  460392
  460727
  461387
  463065
  465276
  470957
  471054
  473617
  475866
  477036
  477051
  477392
  480613
  495808
  498847
  499037
  503941
  505960
  505987
  506853
  511717
  513591
  513865
  516783
  517020
  518231
  520024
  521845
  522669
  525141
  537161
  549153
  550478
  550720
  555254
  557090
  558220
  559573
  560516
  561942
  563612
  564695
  578856
  579196
  580651
  584867
  600737
  603925
  608036
  610275
  614007
  614443
  619344
  622323
  623392
  624920
  626067
  663318
  670620
  672251
  676664
  695338
  697181
  700905
  705020
  705080
  707233
  714819
  721580
  723601
  726598
  728009
  728277
  728808
  740051
  740129
  742871
  743196
  745866
  747170
  748337
  750836
  752301
  758848
  758895
  759635
  760193
  764668
  776703
  777937
  779768
  780805
  782346
  788223
  789291
  796626
  797440
  799365
  801329
  802562
  807284
  807296
  807453
  807488
  810037
  811042
  823747
  824250
  827233
]
21.42 ms
(13.32%)
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
  670620
  460119
  475866
  525141
  498847
  740051
  663318
  600737
  477051
  721580
  461387
  584867
  776703
  454868
  499037
  506853
  495808
  455179
  518231
  750836
  752301
  780805
  788223
  811042
  389821
  824250
  723601
  560516
  550720
  714819
  700905
  610275
  777937
  789291
  807453
  807284
  807296
  807488
  774140
  764668
  564695
  477392
  810037
  555254
  705080
  676664
  705020
  614007
  622323
  697181
  463065
  513865
  457658
  758895
  460392
  480613
  431521
  827233
  465276
  517020
  740129
  745866
  758848
  516783
  563612
  470957
  801329
  603925
  623392
  459947
  537161
  557090
  580651
  477036
  624920
  779768
  799365
  759635
  460727
  614443
  471054
  513591
  503941
  505960
  521845
  550478
  672251
  707233
  802562
  747170
  782346
  743196
  436490
  452782
  549153
  578856
  608036
  742871
  728009
  579196
  626067
  522669
  425749
  619344
  823747
  561942
  695338
  760193
  726598
  728808
  796626
  797440
  728277
  505987
  559573
  558220
  748337
  473617
  520024
  511717
]
2.27 ms
(1.41%)
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
  389821
  425749
  431521
  436490
  452782
  454868
  455179
  457658
  459947
  460119
  460392
  460727
  461387
  463065
  465276
  470957
  471054
  473617
  475866
  477036
  477051
  477392
  480613
  495808
  498847
  499037
  503941
  505960
  505987
  506853
  511717
  513591
  513865
  516783
  517020
  518231
  520024
  521845
  522669
  525141
  537161
  549153
  550478
  550720
  555254
  557090
  558220
  559573
  560516
  561942
  563612
  564695
  578856
  579196
  580651
  584867
  600737
  603925
  608036
  610275
  614007
  614443
  619344
  622323
  623392
  624920
  626067
  663318
  670620
  672251
  676664
  695338
  697181
  700905
  705020
  705080
  707233
  714819
  721580
  723601
  726598
  728009
  728277
  728808
  740051
  740129
  742871
  743196
  745866
  747170
  748337
  750836
  752301
  758848
  758895
  759635
  760193
  764668
  776703
  777937
  779768
  780805
  782346
  788223
  789291
  796626
  797440
  799365
  801329
  802562
  807284
  807296
  807453
  807488
  810037
  811042
  823747
  824250
  827233
]
2.06 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "домашнее спящие миньет"
]
1.63 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск спящ минет оральн секс"
]
1.35 ms
(0.84%)
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.