Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.39 ms
(85.03%)
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
  202902
  385683
  395622
  396352
  400482
  402262
  417960
  419073
  419420
  425667
  435019
  439615
  443599
  447077
  447229
  447333
  454856
  455031
  455836
  457138
  457266
  458076
  462294
  463753
  467934
  468600
  470767
  471500
  473091
  475100
  475979
  476485
  479995
  480419
  480705
  482867
  485059
  487129
  491363
  491475
  492245
  495035
  496086
  496451
  499147
  499444
  503370
  504271
  508078
  508934
  509509
  511217
  514030
  514407
  518334
  520489
  521899
  524012
  524298
  525685
  529238
  529432
  535306
  543361
  545601
  547729
  552441
  554743
  558359
  558742
  560160
  560737
  562734
  564651
  565158
  565551
  567537
  567821
  567860
  569675
  572827
  573451
  574839
  575140
  578060
  579215
  579935
  580141
  585767
  586403
  588305
  589360
  593850
  597830
  598731
  599567
  621122
  625729
  634517
  646219
  654846
  656407
  663914
  665926
  670295
  677364
  679350
  679376
  702927
  718160
  720871
  741929
  761573
  762234
  767384
  771971
  790397
  799714
  803596
  807469
]
16.21 ms
(9.23%)
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
  508078
  503370
  767384
  574839
  799714
  496451
  514407
  807469
  471500
  665926
  447333
  524298
  654846
  508934
  492245
  803596
  385683
  400482
  482867
  468600
  499147
  598731
  575140
  504271
  562734
  552441
  475979
  567821
  457266
  656407
  435019
  521899
  565158
  455836
  529432
  761573
  547729
  463753
  509509
  580141
  402262
  455031
  480419
  480705
  579215
  479995
  396352
  670295
  589360
  741929
  417960
  578060
  443599
  599567
  625729
  573451
  585767
  525685
  679350
  558359
  579935
  511217
  790397
  720871
  560160
  564651
  679376
  495035
  447229
  593850
  425667
  473091
  395622
  572827
  543361
  491475
  467934
  677364
  514030
  202902
  569675
  646219
  447077
  496086
  554743
  454856
  621122
  597830
  567860
  458076
  524012
  419420
  663914
  762234
  586403
  634517
  702927
  535306
  419073
  491363
  718160
  457138
  545601
  567537
  565551
  520489
  470767
  560737
  558742
  476485
  487129
  588305
  485059
  499444
  475100
  439615
  771971
  518334
  529238
  462294
]
3.26 ms
(1.86%)
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
  202902
  385683
  395622
  396352
  400482
  402262
  417960
  419073
  419420
  425667
  435019
  439615
  443599
  447077
  447229
  447333
  454856
  455031
  455836
  457138
  457266
  458076
  462294
  463753
  467934
  468600
  470767
  471500
  473091
  475100
  475979
  476485
  479995
  480419
  480705
  482867
  485059
  487129
  491363
  491475
  492245
  495035
  496086
  496451
  499147
  499444
  503370
  504271
  508078
  508934
  509509
  511217
  514030
  514407
  518334
  520489
  521899
  524012
  524298
  525685
  529238
  529432
  535306
  543361
  545601
  547729
  552441
  554743
  558359
  558742
  560160
  560737
  562734
  564651
  565158
  565551
  567537
  567821
  567860
  569675
  572827
  573451
  574839
  575140
  578060
  579215
  579935
  580141
  585767
  586403
  588305
  589360
  593850
  597830
  598731
  599567
  621122
  625729
  634517
  646219
  654846
  656407
  663914
  665926
  670295
  677364
  679350
  679376
  702927
  718160
  720871
  741929
  761573
  762234
  767384
  771971
  790397
  799714
  803596
  807469
]
2.16 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blowjob pretty girl"
]
1.99 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "минет оральн секс pretty девушк"
]
1.26 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "минет оральн секс pretty девушк"
]

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.