Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
413.97 ms
(68.56%)
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
  382542
  385505
  386929
  388205
  392622
  402807
  412539
  418774
  421488
  423763
  425654
  428220
  430433
  430675
  432776
  436005
  443250
  445192
  446095
  448396
  450690
  455015
  464200
  464721
  469140
  473237
  473416
  473574
  473636
  475695
  478508
  487537
  490446
  490636
  492072
  494177
  500022
  503427
  512081
  513938
  519744
  520789
  526498
  528183
  537051
  540583
  544509
  552814
  554371
  554947
  559770
  560287
  567063
  567601
  567990
  570754
  572205
  573993
  577531
  577581
  579726
  585650
  590778
  599502
  600724
  600788
  601862
  617066
  624902
  628710
  632090
  658796
  658907
  662134
  666055
  673797
  701761
  704039
  706136
  707539
  711761
  714322
  724636
  726503
  726512
  726558
  727808
  740492
  742834
  750148
  750976
  752605
  752653
  757232
  757402
  757825
  776080
  780267
  784593
  784874
  785179
  787510
  788524
  792936
  794223
  796715
  796976
  799601
  800535
  800662
  803488
  803832
  806733
  807011
  807293
  807619
  808547
  811057
  811696
  812893
]
157.49 ms
(26.08%)
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
  382542
  385505
  386929
  388205
  392622
  402807
  412539
  418774
  421488
  423763
  425654
  428220
  430433
  430675
  432776
  436005
  443250
  445192
  446095
  448396
  450690
  455015
  464200
  464721
  469140
  473237
  473416
  473574
  473636
  475695
  478508
  487537
  490446
  490636
  492072
  494177
  500022
  503427
  512081
  513938
  519744
  520789
  526498
  528183
  537051
  540583
  544509
  552814
  554371
  554947
  559770
  560287
  567063
  567601
  567990
  570754
  572205
  573993
  577531
  577581
  579726
  585650
  590778
  599502
  600724
  600788
  601862
  617066
  624902
  628710
  632090
  658796
  658907
  662134
  666055
  673797
  701761
  704039
  706136
  707539
  711761
  714322
  724636
  726503
  726512
  726558
  727808
  740492
  742834
  750148
  750976
  752605
  752653
  757232
  757402
  757825
  776080
  780267
  784593
  784874
  785179
  787510
  788524
  792936
  794223
  796715
  796976
  799601
  800535
  800662
  803488
  803832
  806733
  807011
  807293
  807619
  808547
  811057
  811696
  812893
]
25.10 ms
(4.16%)
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
  803832
  811696
  776080
  812893
  727808
  726558
  757402
  757232
  617066
  704039
  780267
  784874
  792936
  808547
  392622
  513938
  490446
  492072
  494177
  473574
  567990
  388205
  386929
  443250
  577531
  624902
  469140
  478508
  526498
  512081
  450690
  385505
  382542
  520789
  560287
  579726
  707539
  475695
  701761
  428220
  412539
  503427
  464200
  572205
  573993
  666055
  706136
  662134
  714322
  600788
  599502
  796715
  787510
  788524
  800662
  803488
  726503
  794223
  757825
  752605
  711761
  785179
  423763
  487537
  490636
  658907
  726512
  421488
  430433
  540583
  544509
  552814
  799601
  742834
  445192
  796976
  750976
  418774
  402807
  436005
  473636
  446095
  554947
  600724
  800535
  740492
  724636
  752653
  784593
  455015
  473237
  473416
  519744
  528183
  500022
  567601
  570754
  567063
  585650
  806733
  464721
  430675
  432776
  537051
  554371
  577581
  658796
  673797
  559770
  601862
  628710
  632090
  590778
  807293
  807011
  811057
  750148
  807619
  448396
  425654
]
2.01 ms
(0.33%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(0.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "мастурбирует пока трахает"
]
1.76 ms
(0.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мастурбац пок секс"
]
1.61 ms
(0.27%)
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.