Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
163.84 ms
(83.23%)
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
  413096
  426084
  428406
  439219
  447105
  448521
  453672
  455020
  455210
  456423
  457786
  458694
  459107
  460289
  460756
  461932
  462279
  464732
  465384
  466065
  466069
  466075
  466223
  466253
  466255
  467773
  467783
  469763
  470257
  470539
  470547
  470640
  471003
  473586
  474029
  475927
  476244
  476935
  477930
  478558
  479049
  479069
  479149
  483352
  484636
  484669
  484703
  484706
  484977
  485940
  486385
  490840
  492048
  495710
  500599
  501382
  502119
  502480
  502482
  504231
  505694
  508497
  509813
  509841
  509910
  511193
  511739
  512560
  514641
  517125
  517616
  518003
  519776
  520468
  521977
  522314
  525702
  527656
  533703
  535306
  542760
  543587
  544112
  544398
  545187
  546722
  546771
  549783
  550302
  551553
  551572
  551579
  552099
  557941
  557956
  559026
  559080
  564116
  575189
  579317
  590472
  590628
  595950
  598606
  603663
  608926
  625385
  670056
  674495
  720878
  730497
  740212
  757638
  765841
  779591
  792277
  797381
  797849
  800316
  821840
]
22.33 ms
(11.34%)
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
  590472
  779591
  765841
  800316
  467783
  478558
  467773
  509841
  476935
  486385
  579317
  470539
  466223
  514641
  517125
  461932
  502119
  533703
  542760
  720878
  439219
  527656
  492048
  505694
  559026
  511739
  517616
  543587
  797381
  730497
  459107
  479069
  520468
  484706
  512560
  502482
  457786
  501382
  550302
  595950
  509813
  508497
  479149
  475927
  518003
  525702
  670056
  625385
  448521
  511193
  564116
  413096
  470257
  519776
  484977
  608926
  557956
  484636
  466069
  522314
  551579
  557941
  466075
  484703
  792277
  603663
  474029
  797849
  502480
  484669
  740212
  477930
  590628
  483352
  544398
  551572
  545187
  757638
  456423
  465384
  500599
  490840
  546722
  575189
  466253
  466255
  535306
  428406
  504231
  598606
  544112
  546771
  549783
  559080
  470547
  521977
  466065
  552099
  471003
  447105
  476244
  462279
  460756
  821840
  674495
  470640
  453672
  458694
  426084
  455210
  509910
  485940
  551553
  473586
  469763
  495710
  479049
  460289
  464732
  455020
]
3.49 ms
(1.77%)
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
  413096
  426084
  428406
  439219
  447105
  448521
  453672
  455020
  455210
  456423
  457786
  458694
  459107
  460289
  460756
  461932
  462279
  464732
  465384
  466065
  466069
  466075
  466223
  466253
  466255
  467773
  467783
  469763
  470257
  470539
  470547
  470640
  471003
  473586
  474029
  475927
  476244
  476935
  477930
  478558
  479049
  479069
  479149
  483352
  484636
  484669
  484703
  484706
  484977
  485940
  486385
  490840
  492048
  495710
  500599
  501382
  502119
  502480
  502482
  504231
  505694
  508497
  509813
  509841
  509910
  511193
  511739
  512560
  514641
  517125
  517616
  518003
  519776
  520468
  521977
  522314
  525702
  527656
  533703
  535306
  542760
  543587
  544112
  544398
  545187
  546722
  546771
  549783
  550302
  551553
  551572
  551579
  552099
  557941
  557956
  559026
  559080
  564116
  575189
  579317
  590472
  590628
  595950
  598606
  603663
  608926
  625385
  670056
  674495
  720878
  730497
  740212
  757638
  765841
  779591
  792277
  797381
  797849
  800316
  821840
]
2.11 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian amateur threesome"
]
1.75 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск любительск секс втро"
]
1.68 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.