Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.35 ms
(83.98%)
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
  188282
  392739
  399966
  400487
  406969
  418916
  426940
  428146
  428843
  452308
  453444
  458721
  459887
  462455
  468307
  472675
  476247
  479493
  480246
  485922
  512100
  513194
  527668
  532821
  538972
  552762
  558226
  561460
  562018
  586150
  591048
  599518
  601986
  606685
  618910
  621488
  625268
  631292
  666091
  670749
  678986
  682065
  689558
  697512
  700827
  703900
  710119
  712176
  712679
  714049
  714750
  714868
  716178
  720899
  722346
  723961
  725182
  725226
  726841
  730526
  733514
  734040
  736130
  742271
  742276
  742283
  745974
  745987
  745996
  747421
  755611
  758314
  759905
  761230
  761253
  765580
  769494
  777135
  781650
  783115
  784653
  786569
  788943
  789353
  789365
  789617
  789630
  792631
  793577
  794102
  795127
  798820
  799360
  799962
  799966
  800935
  802177
  802670
  802937
  803522
  803787
  804552
  805819
  806356
  811145
  812785
  813608
  813750
  816696
  817551
  817574
  817585
  817972
  817991
  818497
  824446
  825380
  825940
  828335
]
12.99 ms
(9.06%)
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
  733514
  730526
  742283
  714750
  781650
  392739
  813750
  462455
  532821
  538972
  802177
  759905
  806356
  406969
  485922
  817551
  824446
  825940
  816696
  817991
  817585
  817972
  825380
  817574
  818497
  828335
  670749
  720899
  784653
  789353
  789365
  789630
  734040
  742271
  755611
  761253
  783115
  803787
  725226
  745987
  745996
  777135
  794102
  799360
  452308
  512100
  418916
  428146
  714868
  804552
  742276
  761230
  631292
  527668
  813608
  453444
  479493
  552762
  561460
  562018
  558226
  700827
  714049
  716178
  722346
  678986
  682065
  710119
  666091
  689558
  697512
  712176
  712679
  606685
  621488
  586150
  618910
  786569
  789617
  800935
  803361
  812785
  723961
  736130
  758314
  788943
  798820
  802670
  725182
  747421
  745974
  769494
  726841
  601986
  625268
  793577
  795127
  799966
  802937
  805819
  811145
  459887
  591048
  803522
  480246
  476247
  599518
  792631
  765580
  703900
  799962
  400487
  426940
  468307
  472675
  513194
  399966
  188282
  428843
  458721
]
2.65 ms
(1.85%)
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
  188282
  392739
  399966
  400487
  406969
  418916
  426940
  428146
  428843
  452308
  453444
  458721
  459887
  462455
  468307
  472675
  476247
  479493
  480246
  485922
  512100
  513194
  527668
  532821
  538972
  552762
  558226
  561460
  562018
  586150
  591048
  599518
  601986
  606685
  618910
  621488
  625268
  631292
  666091
  670749
  678986
  682065
  689558
  697512
  700827
  703900
  710119
  712176
  712679
  714049
  714750
  714868
  716178
  720899
  722346
  723961
  725182
  725226
  726841
  730526
  733514
  734040
  736130
  742271
  742276
  742283
  745974
  745987
  745996
  747421
  755611
  758314
  759905
  761230
  761253
  765580
  769494
  777135
  781650
  783115
  784653
  786569
  788943
  789353
  789365
  789617
  789630
  792631
  793577
  794102
  795127
  798820
  799360
  799962
  799966
  800935
  802177
  802670
  802937
  803522
  803787
  804552
  805819
  806356
  811145
  812785
  813608
  813750
  816696
  817551
  817574
  817585
  817972
  817991
  818497
  824446
  825380
  825940
  828335
]
2.26 ms
(1.58%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мам женщин stepson"
]
1.71 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин stepson"
]
1.53 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mother stepson"
]

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.