Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
163.63 ms
(86.54%)
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
  47689
  89480
  294490
  383094
  386493
  387664
  388639
  388681
  396988
  405705
  417334
  422267
  424614
  428770
  434667
  436693
  444348
  444852
  446756
  458498
  460562
  462484
  467089
  469373
  471108
  476073
  479426
  482173
  486637
  489355
  489483
  489603
  491732
  491769
  492138
  492276
  496164
  496595
  506252
  508819
  509114
  509408
  511162
  513188
  515416
  517810
  519675
  520926
  521722
  522214
  523005
  523679
  525957
  526070
  532817
  534630
  541337
  543317
  545247
  549105
  555020
  557502
  558952
  559601
  561640
  563647
  568373
  568546
  569092
  569103
  569108
  569120
  569193
  569202
  569214
  569228
  569524
  569536
  569538
  570146
  574803
  575067
  576360
  576514
  585020
  585959
  588517
  588538
  589756
  591087
  591097
  592335
  592662
  595209
  599140
  620725
  640686
  651684
  655861
  667253
  667476
  672140
  704857
  706935
  709645
  713718
  716550
  728465
  732990
  737857
  748521
  750602
  770387
  778195
  788852
  789566
  796831
  796843
  808155
  814401
]
16.47 ms
(8.71%)
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
  543317
  706935
  796831
  506252
  525957
  294490
  434667
  444852
  476073
  509114
  492276
  569538
  570146
  569108
  575067
  651684
  569103
  591087
  732990
  396988
  386493
  89480
  388639
  387664
  424614
  422267
  585020
  462484
  467089
  532817
  513188
  479426
  492138
  545247
  559601
  569202
  576514
  569120
  569228
  549105
  557502
  569193
  569214
  574803
  655861
  667476
  716550
  667253
  704857
  713718
  709645
  558952
  563647
  568373
  588538
  592335
  640686
  588517
  591097
  592662
  589756
  599140
  778195
  796843
  788852
  728465
  737857
  750602
  748521
  770387
  789566
  388681
  405705
  428770
  436693
  471108
  444348
  417334
  523005
  489355
  489483
  496164
  496595
  508819
  511162
  469373
  491769
  534630
  520926
  526070
  555020
  569524
  576360
  541337
  568546
  569092
  672140
  585959
  620725
  808155
  460562
  486637
  491732
  515416
  517810
  489603
  519675
  522214
  523679
  595209
  383094
  47689
  814401
  446756
  482173
  458498
  521722
  509408
  561640
  569536
]
2.57 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
  47689
  89480
  294490
  383094
  386493
  387664
  388639
  388681
  396988
  405705
  417334
  422267
  424614
  428770
  434667
  436693
  444348
  444852
  446756
  458498
  460562
  462484
  467089
  469373
  471108
  476073
  479426
  482173
  486637
  489355
  489483
  489603
  491732
  491769
  492138
  492276
  496164
  496595
  506252
  508819
  509114
  509408
  511162
  513188
  515416
  517810
  519675
  520926
  521722
  522214
  523005
  523679
  525957
  526070
  532817
  534630
  541337
  543317
  545247
  549105
  555020
  557502
  558952
  559601
  561640
  563647
  568373
  568546
  569092
  569103
  569108
  569120
  569193
  569202
  569214
  569228
  569524
  569536
  569538
  570146
  574803
  575067
  576360
  576514
  585020
  585959
  588517
  588538
  589756
  591087
  591097
  592335
  592662
  595209
  599140
  620725
  640686
  651684
  655861
  667253
  667476
  672140
  704857
  706935
  709645
  713718
  716550
  728465
  732990
  737857
  748521
  750602
  770387
  778195
  788852
  789566
  796831
  796843
  808155
  814401
]
1.80 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dirty vagina"
]
1.68 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "dirty вагин"
]
1.50 ms
(0.79%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "dirty вагин"
]

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.