Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.82 ms
(87.55%)
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
  397508
  400581
  418594
  422176
  435502
  439551
  449904
  450847
  451652
  452663
  453710
  453725
  455875
  455943
  457192
  459412
  469604
  482070
  484066
  484498
  485064
  489073
  490763
  493249
  493316
  493851
  495140
  496169
  496553
  496667
  496853
  497935
  498766
  501554
  503004
  507697
  509027
  512589
  512741
  513838
  513915
  514375
  514456
  514638
  517248
  517320
  518607
  518634
  520014
  520283
  522735
  524416
  525590
  526380
  527555
  527641
  527670
  528386
  529420
  529438
  529710
  529777
  535056
  535578
  540071
  547649
  547658
  552350
  555798
  558414
  559933
  561191
  564162
  564327
  564526
  564556
  565631
  566922
  568580
  569014
  569256
  573802
  577612
  581719
  581996
  582694
  583037
  591595
  596823
  597587
  598718
  605162
  610593
  615818
  616778
  617214
  623724
  625144
  625861
  625968
  626126
  632055
  650992
  682303
  714307
  786933
]
20.11 ms
(8.31%)
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
  518607
  522735
  527641
  527670
  518634
  520283
  496169
  498766
  525590
  527555
  489073
  493851
  496667
  512589
  615818
  397508
  418594
  451652
  452663
  457192
  485064
  535578
  496553
  520014
  524416
  526380
  509027
  503004
  552350
  564556
  569256
  573802
  547649
  582694
  583037
  561191
  564526
  566922
  714307
  559933
  565631
  577612
  605162
  597587
  610593
  625144
  623724
  786933
  435502
  439551
  453725
  482070
  455875
  513915
  484066
  493316
  517248
  501554
  514456
  517320
  422176
  459412
  453710
  513838
  529420
  507697
  495140
  528386
  558414
  581719
  569014
  616778
  598718
  617214
  632055
  449904
  529710
  490763
  529438
  455943
  450847
  529777
  535056
  540071
  555798
  568580
  581996
  650992
  682303
  564162
  591595
  400581
  469604
  564327
  625968
  514375
  514638
  484498
  497935
  547658
  596823
  625861
  496853
  512741
  626126
  493249
]
3.18 ms
(1.31%)
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
  397508
  400581
  418594
  422176
  435502
  439551
  449904
  450847
  451652
  452663
  453710
  453725
  455875
  455943
  457192
  459412
  469604
  482070
  484066
  484498
  485064
  489073
  490763
  493249
  493316
  493851
  495140
  496169
  496553
  496667
  496853
  497935
  498766
  501554
  503004
  507697
  509027
  512589
  512741
  513838
  513915
  514375
  514456
  514638
  517248
  517320
  518607
  518634
  520014
  520283
  522735
  524416
  525590
  526380
  527555
  527641
  527670
  528386
  529420
  529438
  529710
  529777
  535056
  535578
  540071
  547649
  547658
  552350
  555798
  558414
  559933
  561191
  564162
  564327
  564526
  564556
  565631
  566922
  568580
  569014
  569256
  573802
  577612
  581719
  581996
  582694
  583037
  591595
  596823
  597587
  598718
  605162
  610593
  615818
  616778
  617214
  623724
  625144
  625861
  625968
  626126
  632055
  650992
  682303
  714307
  786933
]
2.06 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "she is cum"
]
1.97 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "she cum"
]
1.48 ms
(0.61%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.33 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "she cum"
]

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.