Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.09 ms
(83.84%)
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
  391893
  391895
  391929
  401674
  409727
  426710
  426711
  443658
  451555
  454527
  455126
  456432
  456448
  462289
  462560
  463176
  464531
  465388
  466291
  470003
  470500
  470504
  470539
  470586
  470588
  470622
  470625
  470631
  470634
  470643
  470654
  470926
  473788
  473939
  473952
  474632
  475115
  475232
  475945
  476495
  477373
  477943
  477966
  483377
  484402
  484416
  484681
  485493
  488825
  492041
  492048
  493088
  495195
  495738
  502222
  504268
  510426
  512558
  512560
  513608
  517125
  517556
  520135
  520473
  523192
  523305
  524147
  526568
  527030
  530310
  533648
  533658
  533736
  533772
  534070
  535599
  542739
  542744
  542757
  542765
  542770
  542789
  544177
  545027
  545187
  547948
  547952
  551553
  560319
  560454
  566367
  567955
  568666
  576165
  585276
  590472
  590505
  590631
  590693
  616716
  648657
  653527
  670721
  678374
  694639
  720878
  725314
  730497
  731325
  741476
  743644
  753505
  755723
  757638
  758388
  792515
  799672
  809765
  811795
  814320
]
17.35 ms
(10.46%)
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
  451555
  534070
  391895
  547948
  542739
  475232
  456432
  476495
  462289
  470634
  391929
  720878
  492048
  533648
  477373
  520135
  590631
  510426
  753505
  527030
  743644
  533772
  542770
  391893
  512558
  551553
  799672
  811795
  495195
  542765
  470625
  530310
  590472
  535599
  560319
  576165
  616716
  590693
  524147
  523192
  545027
  566367
  648657
  463176
  730497
  792515
  470504
  814320
  462560
  426711
  475115
  426710
  401674
  523305
  456448
  465388
  470654
  504268
  470622
  694639
  741476
  493088
  477943
  545187
  757638
  512560
  809765
  755723
  470643
  678374
  758388
  731325
  542744
  590505
  466291
  473788
  517556
  520473
  502222
  477966
  484416
  533736
  464531
  725314
  485493
  495738
  443658
  470500
  470631
  488825
  513608
  483377
  547952
  474632
  470588
  475945
  470003
  409727
  568666
  670721
  484402
  484681
  560454
  455126
  473939
  473952
  470926
  567955
  585276
  526568
  542757
  454527
  470586
  544177
  533658
  470539
  492041
  517125
  542789
  653527
]
2.52 ms
(1.52%)
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
  391893
  391895
  391929
  401674
  409727
  426710
  426711
  443658
  451555
  454527
  455126
  456432
  456448
  462289
  462560
  463176
  464531
  465388
  466291
  470003
  470500
  470504
  470539
  470586
  470588
  470622
  470625
  470631
  470634
  470643
  470654
  470926
  473788
  473939
  473952
  474632
  475115
  475232
  475945
  476495
  477373
  477943
  477966
  483377
  484402
  484416
  484681
  485493
  488825
  492041
  492048
  493088
  495195
  495738
  502222
  504268
  510426
  512558
  512560
  513608
  517125
  517556
  520135
  520473
  523192
  523305
  524147
  526568
  527030
  530310
  533648
  533658
  533736
  533772
  534070
  535599
  542739
  542744
  542757
  542765
  542770
  542789
  544177
  545027
  545187
  547948
  547952
  551553
  560319
  560454
  566367
  567955
  568666
  576165
  585276
  590472
  590505
  590631
  590693
  616716
  648657
  653527
  670721
  678374
  694639
  720878
  725314
  730497
  731325
  741476
  743644
  753505
  755723
  757638
  758388
  792515
  799672
  809765
  811795
  814320
]
1.96 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian wife threesome"
]
1.95 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск жен секс втро"
]
1.59 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.87%)
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.