Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.45 ms
(81.68%)
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
  391925
  400989
  401575
  419619
  423856
  423972
  437599
  438324
  439715
  442913
  447204
  460540
  460754
  470064
  470690
  470898
  491429
  495562
  495700
  497345
  499643
  504211
  507197
  508393
  508678
  510504
  513374
  513592
  516941
  517304
  517816
  522931
  525470
  527180
  539366
  540713
  540746
  546720
  547748
  547751
  547780
  548024
  559467
  563029
  564647
  571508
  573732
  579883
  582500
  588988
  590205
  590246
  592862
  596841
  606032
  609432
  609966
  611506
  620233
  623398
  624888
  656138
  660696
  672809
  689161
  697720
  705022
  707507
  711590
  712308
  714319
  714322
  714336
  714346
  714789
  718774
  722955
  724809
  725464
  730987
  736905
  737438
  738365
  740919
  742839
  744479
  751570
  751576
  754037
  755022
  756601
  765821
  765828
  765845
  771576
  775848
  776035
  777727
  777823
  779566
  780340
  782317
  786428
  788084
  789460
  790534
  791516
  791759
  791921
  793295
  796538
  803142
  804927
  806952
  807353
  812593
  814226
  816691
  818368
]
19.99 ms
(12.14%)
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
  786428
  790534
  791759
  803142
  391925
  513374
  423972
  571508
  775848
  517816
  527180
  401575
  470064
  547751
  606032
  596841
  590205
  419619
  439715
  513592
  460754
  548024
  656138
  504211
  442913
  495562
  491429
  818368
  816691
  497345
  540746
  714336
  714346
  714322
  547780
  579883
  590246
  620233
  624888
  611506
  779566
  807353
  812593
  777727
  793295
  796538
  806952
  737438
  742839
  751576
  791516
  765821
  736905
  755022
  765845
  751570
  756601
  765828
  724809
  740919
  754037
  771576
  609966
  623398
  711590
  776035
  777823
  780340
  782317
  791921
  438324
  470898
  499643
  522931
  525470
  507197
  788084
  564647
  592862
  495700
  539366
  559467
  470690
  730987
  725464
  804927
  563029
  609432
  546720
  588988
  400989
  460540
  447204
  508393
  510504
  516941
  573732
  660696
  423856
  437599
  508678
  513476
  722955
  789460
  744479
  738365
  672809
  689161
  707507
  712308
  714789
  705022
  517304
  814226
  540713
  582500
  697720
  714319
  718774
  547748
]
2.87 ms
(1.74%)
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
  391925
  400989
  401575
  419619
  423856
  423972
  437599
  438324
  439715
  442913
  447204
  460540
  460754
  470064
  470690
  470898
  491429
  495562
  495700
  497345
  499643
  504211
  507197
  508393
  508678
  510504
  513374
  513592
  516941
  517304
  517816
  522931
  525470
  527180
  539366
  540713
  540746
  546720
  547748
  547751
  547780
  548024
  559467
  563029
  564647
  571508
  573732
  579883
  582500
  588988
  590205
  590246
  592862
  596841
  606032
  609432
  609966
  611506
  620233
  623398
  624888
  656138
  660696
  672809
  689161
  697720
  705022
  707507
  711590
  712308
  714319
  714322
  714336
  714346
  714789
  718774
  722955
  724809
  725464
  730987
  736905
  737438
  738365
  740919
  742839
  744479
  751570
  751576
  754037
  755022
  756601
  765821
  765828
  765845
  771576
  775848
  776035
  777727
  777823
  779566
  780340
  782317
  786428
  788084
  789460
  790534
  791516
  791759
  791921
  793295
  796538
  803142
  804927
  806952
  807353
  812593
  814226
  816691
  818368
]
1.88 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русская милфа домашне…"
]
1.87 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск милф домашн любительск"
]
1.84 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(1.04%)
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.