Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
191.83 ms
(87.63%)
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
  340635
  391923
  409083
  419554
  422338
  424426
  427100
  439518
  442997
  443360
  443670
  443673
  443704
  443725
  443726
  443760
  443763
  443787
  443792
  443793
  443809
  444000
  448714
  449178
  451473
  454248
  455373
  456516
  460745
  460924
  461944
  462019
  462022
  462126
  462522
  464326
  464944
  465952
  466195
  466269
  467893
  467905
  468072
  468897
  470503
  470514
  470692
  470763
  470922
  474214
  474700
  476252
  476339
  477707
  477934
  477980
  477989
  479139
  484359
  484365
  484392
  484573
  484591
  484605
  484630
  484670
  485696
  485774
  485924
  486915
  489087
  490914
  491986
  494296
  496506
  500414
  501997
  506028
  509430
  510533
  510794
  511375
  517021
  518842
  518853
  519753
  520894
  523031
  525468
  525884
  526729
  526737
  529245
  544502
  546939
  547601
  547928
  549771
  558314
  559057
  576643
  583615
  590258
  591922
  592985
  610695
  658797
  678716
  714468
  714476
  725239
  731398
  733254
  754656
  766349
  803404
  807340
  807884
  811736
  826789
]
17.70 ms
(8.08%)
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
  523031
  470922
  443360
  526729
  549771
  424426
  443787
  449178
  519753
  558314
  678716
  714476
  658797
  592985
  509430
  525468
  476252
  807340
  442997
  444000
  466269
  451473
  465952
  485696
  484392
  500414
  477707
  510533
  547601
  547928
  559057
  590258
  811736
  340635
  409083
  462022
  419554
  477989
  443725
  443760
  526737
  484591
  501997
  484573
  484605
  506028
  529245
  511375
  462522
  477934
  731398
  826789
  517021
  803404
  754656
  725239
  733254
  766349
  807884
  391923
  464326
  439518
  443704
  468072
  484365
  518853
  525884
  443793
  461944
  468897
  489087
  546939
  462126
  448714
  477980
  470503
  443673
  462019
  496506
  474700
  484670
  484630
  583615
  576643
  443809
  456516
  460745
  467893
  464944
  466195
  443670
  460924
  470763
  476339
  422338
  443726
  443763
  443792
  454248
  470514
  518842
  485774
  486915
  484359
  491986
  494296
  610695
  470692
  485924
  479139
  474214
  510794
  520894
  490914
  544502
  714468
  591922
  467905
  455373
  427100
]
2.99 ms
(1.36%)
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
  340635
  391923
  409083
  419554
  422338
  424426
  427100
  439518
  442997
  443360
  443670
  443673
  443704
  443725
  443726
  443760
  443763
  443787
  443792
  443793
  443809
  444000
  448714
  449178
  451473
  454248
  455373
  456516
  460745
  460924
  461944
  462019
  462022
  462126
  462522
  464326
  464944
  465952
  466195
  466269
  467893
  467905
  468072
  468897
  470503
  470514
  470692
  470763
  470922
  474214
  474700
  476252
  476339
  477707
  477934
  477980
  477989
  479139
  484359
  484365
  484392
  484573
  484591
  484605
  484630
  484670
  485696
  485774
  485924
  486915
  489087
  490914
  491986
  494296
  496506
  500414
  501997
  506028
  509430
  510533
  510794
  511375
  517021
  518842
  518853
  519753
  520894
  523031
  525468
  525884
  526729
  526737
  529245
  544502
  546939
  547601
  547928
  549771
  558314
  559057
  576643
  583615
  590258
  591922
  592985
  610695
  658797
  678716
  714468
  714476
  725239
  731398
  733254
  754656
  766349
  803404
  807340
  807884
  811736
  826789
]
1.87 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian hairy mature"
]
1.64 ms
(0.75%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(0.69%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск волосатая mature"
]
1.37 ms
(0.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск волосатая mature"
]

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.