Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.79 ms
(84.60%)
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
  183044
  391604
  413404
  413958
  416694
  418219
  427311
  430374
  434374
  434376
  434654
  435722
  444544
  448522
  451852
  454009
  454467
  455079
  455471
  459646
  460804
  463793
  464217
  466467
  467877
  467908
  473051
  475416
  475647
  475649
  493220
  495747
  499789
  500299
  505328
  510898
  511379
  512994
  515440
  515994
  521831
  522094
  531677
  535279
  552567
  552608
  555288
  555297
  564510
  564563
  573403
  576925
  579457
  580207
  581236
  581995
  583665
  585253
  596929
  602614
  624942
  643516
  651850
  656931
  661455
  662129
  685807
  700997
  710265
  713163
  713877
  715283
  717550
  720190
  720756
  724039
  726064
  728930
  729312
  735772
  736959
  749924
  752652
  754470
  757395
  758780
  760254
  761461
  761530
  765388
  769792
  770376
  777847
  782547
  782731
  783962
  784713
  784750
  785510
  785574
  786872
  787952
  790069
  791365
  791623
  796904
  797065
  798639
  800633
  801655
  803633
  803676
  805335
  806924
  806947
  806952
  824320
  825818
  826455
]
13.66 ms
(9.04%)
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
  643516
  454467
  651850
  451852
  467908
  475647
  717550
  585253
  455471
  512994
  580207
  581236
  564563
  466467
  183044
  801655
  729312
  785510
  749924
  564510
  777847
  715283
  803633
  511379
  624942
  825818
  761530
  602614
  783962
  724039
  806947
  463793
  573403
  435722
  552608
  552567
  784750
  473051
  720756
  434654
  434376
  493220
  455079
  521831
  713877
  791365
  769792
  736959
  475416
  467877
  581995
  505328
  786872
  720190
  713163
  661455
  796904
  791623
  761461
  535279
  475649
  430374
  500299
  596929
  784713
  798639
  806952
  803676
  510898
  515994
  522094
  728930
  427311
  444544
  662129
  495747
  807580
  434374
  515440
  416694
  413404
  824320
  576925
  579457
  782547
  805335
  787952
  790069
  760254
  752652
  735772
  448522
  499789
  460804
  656931
  765388
  454009
  418219
  555288
  806924
  754470
  726064
  413958
  459646
  700997
  800633
  770376
  797065
  391604
  757395
  583665
  826455
  531677
  685807
  782731
  785574
  555297
  710265
  464217
  758780
]
3.09 ms
(2.04%)
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
  183044
  391604
  413404
  413958
  416694
  418219
  427311
  430374
  434374
  434376
  434654
  435722
  444544
  448522
  451852
  454009
  454467
  455079
  455471
  459646
  460804
  463793
  464217
  466467
  467877
  467908
  473051
  475416
  475647
  475649
  493220
  495747
  499789
  500299
  505328
  510898
  511379
  512994
  515440
  515994
  521831
  522094
  531677
  535279
  552567
  552608
  555288
  555297
  564510
  564563
  573403
  576925
  579457
  580207
  581236
  581995
  583665
  585253
  596929
  602614
  624942
  643516
  651850
  656931
  661455
  662129
  685807
  700997
  710265
  713163
  713877
  715283
  717550
  720190
  720756
  724039
  726064
  728930
  729312
  735772
  736959
  749924
  752652
  754470
  757395
  758780
  760254
  761461
  761530
  765388
  769792
  770376
  777847
  782547
  782731
  783962
  784713
  784750
  785510
  785574
  786872
  787952
  790069
  791365
  791623
  796904
  797065
  798639
  800633
  801655
  803633
  803676
  805335
  806924
  806947
  806952
  824320
  825818
  826455
]
1.80 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade anal squirt"
]
1.65 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск анал сквирт оргазм"
]
1.45 ms
(0.96%)
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.