Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
206.87 ms
(57.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "massage vagina"
]
124.10 ms
(34.76%)
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
  122425
  383053
  385057
  386719
  401362
  402252
  403039
  404478
  405088
  405224
  417662
  418704
  418922
  419145
  422233
  427550
  429226
  430285
  430811
  432404
  435358
  444446
  447562
  450254
  454727
  456179
  466940
  477810
  479176
  480368
  484539
  497029
  498668
  498816
  499834
  501746
  504681
  506629
  506669
  506702
  509780
  511931
  513540
  519946
  520726
  521915
  526704
  531903
  539417
  543499
  545809
  551283
  551298
  551388
  552127
  554764
  555177
  559958
  561356
  564616
  564626
  564631
  569822
  574890
  576379
  576841
  584759
  587879
  591265
  593174
  594803
  595516
  598315
  600577
  603736
  605411
  610266
  612348
  618943
  621527
  622329
  636520
  643886
  648587
  651882
  653254
  659905
  661881
  663098
  663494
  663663
  664324
  666321
  673093
  676499
  676518
  697916
  709769
  719504
  749003
  750376
  757995
  758719
  759547
  760361
  762205
  762556
  765522
  771584
  773187
  789240
  792031
  794659
  796865
  797221
  797678
  798765
  814570
  815937
  816875
]
17.94 ms
(5.02%)
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
  506669
  402252
  417662
  484539
  663494
  545809
  564631
  587879
  405224
  497029
  499834
  501746
  418704
  622329
  427550
  539417
  551388
  663663
  792031
  612348
  659905
  653254
  765522
  816875
  648587
  719504
  651882
  663098
  676518
  636520
  605411
  593174
  797221
  762556
  749003
  757995
  760361
  466940
  444446
  122425
  403039
  511931
  520726
  551298
  564626
  569822
  673093
  664324
  551283
  610266
  430285
  479176
  405088
  429226
  498668
  504681
  509780
  418922
  498816
  576379
  600577
  506702
  454727
  543499
  595516
  456179
  621527
  618943
  401362
  435358
  531903
  552127
  561356
  555177
  758719
  422233
  432404
  419145
  447562
  513540
  521915
  576841
  598315
  643886
  385057
  480368
  526704
  564616
  591265
  773187
  794659
  798765
  762205
  386719
  383053
  814570
  815937
  477810
  666321
  697916
  661881
  676499
  709769
  594803
  797678
  789240
  759547
  771584
  750376
  796865
  603736
  506629
  584759
  430811
  404478
  450254
  519946
  574890
  554764
  559958
]
2.98 ms
(0.83%)
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
  122425
  383053
  385057
  386719
  401362
  402252
  403039
  404478
  405088
  405224
  417662
  418704
  418922
  419145
  422233
  427550
  429226
  430285
  430811
  432404
  435358
  444446
  447562
  450254
  454727
  456179
  466940
  477810
  479176
  480368
  484539
  497029
  498668
  498816
  499834
  501746
  504681
  506629
  506669
  506702
  509780
  511931
  513540
  519946
  520726
  521915
  526704
  531903
  539417
  543499
  545809
  551283
  551298
  551388
  552127
  554764
  555177
  559958
  561356
  564616
  564626
  564631
  569822
  574890
  576379
  576841
  584759
  587879
  591265
  593174
  594803
  595516
  598315
  600577
  603736
  605411
  610266
  612348
  618943
  621527
  622329
  636520
  643886
  648587
  651882
  653254
  659905
  661881
  663098
  663494
  663663
  664324
  666321
  673093
  676499
  676518
  697916
  709769
  719504
  749003
  750376
  757995
  758719
  759547
  760361
  762205
  762556
  765522
  771584
  773187
  789240
  792031
  794659
  796865
  797221
  797678
  798765
  814570
  815937
  816875
]
1.75 ms
(0.49%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(0.49%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "массаж вагин"
]
1.62 ms
(0.45%)
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.