Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.26 ms
(85.37%)
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
  223663
  382861
  388185
  409050
  413254
  471066
  490437
  500689
  500692
  539892
  541034
  545155
  545735
  545740
  545742
  546146
  550530
  557607
  569661
  576237
  576766
  576791
  587805
  594426
  606097
  609073
  612622
  619620
  621051
  626169
  627232
  628568
  629695
  640448
  641300
  643943
  644199
  648017
  648273
  652163
  666062
  666094
  666670
  667113
  668007
  668023
  668027
  676677
  684752
  684792
  697177
  697303
  701059
  703709
  703748
  703772
  703783
  706391
  708035
  713063
  714366
  714407
  714569
  715703
  716293
  718806
  719781
  722167
  724503
  724505
  724667
  727985
  728148
  728952
  728955
  728984
  729045
  729050
  729051
  729932
  730318
  730323
  733307
  733342
  734205
  734207
  735391
  735435
  735976
  736036
  736671
  739895
  739969
  740541
  740666
  742863
  744140
  744805
  747251
  748478
  748517
  748526
  749487
  758913
  759701
  767560
  773866
  778481
  794570
  794632
  795812
  800737
  802272
  803927
  807827
  815222
  819307
  827272
  827577
  827585
]
11.26 ms
(8.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
  569661
  794632
  748478
  545740
  545155
  541034
  545742
  703748
  714366
  667113
  684792
  697177
  706391
  668027
  684752
  626169
  629695
  628568
  606097
  641300
  643943
  729932
  734207
  749487
  728952
  728955
  739969
  744805
  748517
  728984
  729045
  748526
  697303
  714569
  715703
  594426
  758913
  724667
  724505
  730318
  819307
  730323
  500689
  666062
  719781
  733342
  733307
  795812
  223663
  546146
  773866
  716293
  500692
  550530
  827272
  827577
  767560
  409050
  666670
  803927
  727985
  736671
  794570
  802272
  382861
  735435
  471066
  736036
  815222
  718806
  413254
  388185
  744140
  576791
  652163
  666094
  708035
  644199
  587805
  778481
  742863
  724503
  735391
  807827
  490437
  539892
  545735
  576237
  557607
  576766
  701059
  713063
  648273
  668023
  676677
  648017
  668007
  703772
  722167
  609073
  612622
  627232
  640448
  729051
  734205
  740541
  728148
  729050
  739895
  747251
  740666
  703709
  703783
  714407
  735976
  619620
  759701
  800737
  621051
  827585
]
2.36 ms
(1.69%)
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
  223663
  382861
  388185
  409050
  413254
  471066
  490437
  500689
  500692
  539892
  541034
  545155
  545735
  545740
  545742
  546146
  550530
  557607
  569661
  576237
  576766
  576791
  587805
  594426
  606097
  609073
  612622
  619620
  621051
  626169
  627232
  628568
  629695
  640448
  641300
  643943
  644199
  648017
  648273
  652163
  666062
  666094
  666670
  667113
  668007
  668023
  668027
  676677
  684752
  684792
  697177
  697303
  701059
  703709
  703748
  703772
  703783
  706391
  708035
  713063
  714366
  714407
  714569
  715703
  716293
  718806
  719781
  722167
  724503
  724505
  724667
  727985
  728148
  728952
  728955
  728984
  729045
  729050
  729051
  729932
  730318
  730323
  733307
  733342
  734205
  734207
  735391
  735435
  735976
  736036
  736671
  739895
  739969
  740541
  740666
  742863
  744140
  744805
  747251
  748478
  748517
  748526
  749487
  758913
  759701
  767560
  773866
  778481
  794570
  794632
  795812
  800737
  802272
  803927
  807827
  815222
  819307
  827272
  827577
  827585
]
1.95 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big hairy pussy"
]
1.70 ms
(1.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие волосатая pussy"
]
1.47 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие волосатая pussy"
]

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.