Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
150.40 ms
(85.28%)
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
  387428
  388240
  395438
  400463
  421599
  428794
  429927
  430789
  430920
  431182
  435948
  443042
  444516
  447301
  447515
  448520
  451651
  454753
  460218
  460979
  460997
  461655
  462470
  463927
  469762
  470014
  470118
  473388
  475819
  480260
  485336
  487635
  488789
  489431
  491326
  495023
  495588
  497439
  508563
  509010
  509580
  517182
  520690
  520740
  523859
  525646
  533845
  534707
  537686
  543378
  543435
  547136
  556935
  557367
  557685
  565960
  569159
  575192
  575315
  576017
  576396
  579358
  579381
  586986
  592333
  594293
  595435
  595499
  595501
  595518
  595870
  595873
  596577
  596594
  597075
  597493
  597596
  598129
  598261
  598539
  598690
  598746
  598760
  598970
  600125
  615291
  622367
  623963
  624215
  624847
  626354
  629296
  630567
  631620
  633289
  662783
  666871
  667748
  670394
  686255
  697135
  698469
  702335
  714449
  714628
  717890
  718947
  724509
  725132
  735849
  738198
  738737
  747437
  752183
  758561
  783088
  797006
  798243
  799743
  816755
]
15.05 ms
(8.54%)
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
  725132
  747437
  686255
  702335
  783088
  615291
  395438
  717890
  547136
  714628
  622367
  633289
  597596
  738737
  470014
  469762
  596594
  533845
  670394
  752183
  387428
  444516
  595435
  557367
  662783
  697135
  576017
  630567
  738198
  758561
  698469
  797006
  624215
  624847
  718947
  598539
  724509
  480260
  430920
  509010
  626354
  598746
  735849
  428794
  475819
  430789
  443042
  816755
  488789
  525646
  509580
  495588
  557685
  579381
  598690
  623963
  598970
  600125
  595499
  421599
  454753
  460979
  460997
  448520
  470118
  565960
  400463
  388240
  431182
  461655
  447301
  543378
  598261
  594293
  586986
  598129
  435948
  520690
  508563
  495023
  485336
  497439
  592333
  798243
  447515
  487635
  517182
  543435
  556935
  596577
  595870
  597493
  799743
  534707
  714449
  463927
  491326
  473388
  489431
  575192
  595518
  460218
  579358
  451651
  520740
  666871
  523859
  462470
  595873
  429927
  537686
  569159
  598760
  629296
  595501
  667748
  597075
  576396
  575315
  631620
]
3.92 ms
(2.22%)
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
  387428
  388240
  395438
  400463
  421599
  428794
  429927
  430789
  430920
  431182
  435948
  443042
  444516
  447301
  447515
  448520
  451651
  454753
  460218
  460979
  460997
  461655
  462470
  463927
  469762
  470014
  470118
  473388
  475819
  480260
  485336
  487635
  488789
  489431
  491326
  495023
  495588
  497439
  508563
  509010
  509580
  517182
  520690
  520740
  523859
  525646
  533845
  534707
  537686
  543378
  543435
  547136
  556935
  557367
  557685
  565960
  569159
  575192
  575315
  576017
  576396
  579358
  579381
  586986
  592333
  594293
  595435
  595499
  595501
  595518
  595870
  595873
  596577
  596594
  597075
  597493
  597596
  598129
  598261
  598539
  598690
  598746
  598760
  598970
  600125
  615291
  622367
  623963
  624215
  624847
  626354
  629296
  630567
  631620
  633289
  662783
  666871
  667748
  670394
  686255
  697135
  698469
  702335
  714449
  714628
  717890
  718947
  724509
  725132
  735849
  738198
  738737
  747437
  752183
  758561
  783088
  797006
  798243
  799743
  816755
]
2.24 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sexy teen"
]
1.81 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "sexy teen"
]
1.66 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.28 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "sexy teen"
]

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.