Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.76 ms
(81.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
  109176
  373768
  382180
  385755
  386468
  387937
  397265
  398421
  414070
  416620
  416680
  416685
  416824
  416873
  417580
  417621
  418367
  419352
  420277
  420816
  421352
  421971
  422101
  423783
  424271
  425370
  429555
  429766
  432694
  434080
  434104
  434278
  434293
  434339
  435568
  437947
  438615
  439112
  439653
  441952
  442431
  442855
  444052
  445323
  446446
  446785
  446796
  447337
  448000
  448696
  448914
  451266
  452362
  452781
  452922
  453649
  456131
  456161
  456928
  457074
  458034
  458772
  459005
  460338
  460378
  463689
  464844
  468813
  470068
  470430
  471088
  473428
  473723
  473750
  474126
  476646
  476666
  478030
  478519
  478986
  479727
  480203
  493553
  498538
  499059
  499934
  501239
  507696
  509984
  510807
  512143
  516320
  516686
  522046
  523393
  525577
  526584
  527503
  546059
  547767
  552761
  554286
  558171
  563154
  567077
  567676
  570115
  572339
  577513
  579344
  581083
  582552
  588846
  594208
  597810
  601880
  713125
  743029
  775539
  827498
]
19.20 ms
(11.51%)
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
  432694
  434080
  441952
  416685
  434278
  417621
  434104
  453649
  464844
  493553
  457074
  473428
  476646
  526584
  499934
  460378
  473723
  558171
  570115
  572339
  582552
  546059
  552761
  567077
  577513
  563154
  567676
  601880
  588846
  597810
  109176
  416873
  438615
  456928
  468813
  373768
  397265
  416620
  421971
  435568
  452362
  459005
  479727
  417580
  422101
  448914
  458772
  478986
  480203
  416824
  418367
  452922
  456161
  458034
  476666
  478519
  424271
  442431
  470068
  527503
  499059
  512143
  498538
  509984
  523393
  510807
  516320
  827498
  743029
  398421
  382180
  516686
  421352
  452781
  446446
  554286
  439653
  448696
  471088
  423783
  386468
  425370
  434339
  442855
  448000
  713125
  775539
  419352
  429555
  439112
  522046
  525577
  387937
  414070
  420277
  420816
  429766
  437947
  446796
  456131
  470430
  474126
  478030
  446785
  507696
  501239
  581083
  579344
  547767
  594208
  434293
  463689
  460338
  416680
  444052
  451266
  473750
  385755
  445323
  447337
]
3.19 ms
(1.91%)
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
  109176
  373768
  382180
  385755
  386468
  387937
  397265
  398421
  414070
  416620
  416680
  416685
  416824
  416873
  417580
  417621
  418367
  419352
  420277
  420816
  421352
  421971
  422101
  423783
  424271
  425370
  429555
  429766
  432694
  434080
  434104
  434278
  434293
  434339
  435568
  437947
  438615
  439112
  439653
  441952
  442431
  442855
  444052
  445323
  446446
  446785
  446796
  447337
  448000
  448696
  448914
  451266
  452362
  452781
  452922
  453649
  456131
  456161
  456928
  457074
  458034
  458772
  459005
  460338
  460378
  463689
  464844
  468813
  470068
  470430
  471088
  473428
  473723
  473750
  474126
  476646
  476666
  478030
  478519
  478986
  479727
  480203
  493553
  498538
  499059
  499934
  501239
  507696
  509984
  510807
  512143
  516320
  516686
  522046
  523393
  525577
  526584
  527503
  546059
  547767
  552761
  554286
  558171
  563154
  567077
  567676
  570115
  572339
  577513
  579344
  581083
  582552
  588846
  594208
  597810
  601880
  713125
  743029
  775539
  827498
]
2.21 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "дилдо бабы"
]
2.13 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дилд женскийрод"
]
1.59 ms
(0.95%)
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.