Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.74 ms
(86.93%)
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
  75664
  76268
  152276
  184985
  185011
  185208
  185212
  185428
  185464
  185606
  185708
  185834
  185861
  319841
  323129
  357806
  357886
  379578
  382696
  384986
  385096
  386071
  387006
  387487
  389135
  389142
  389304
  390200
  390219
  390592
  390698
  390908
  391064
  391677
  400435
  401492
  402601
  402604
  402605
  404032
  406235
  408060
  408085
  408172
  412222
  413300
  415934
  424571
  426894
  427925
  447493
  448652
  486924
  494578
  501718
  501720
  501750
  506960
  511294
  514568
  523971
  525251
  555944
  562881
  563715
  569827
  572018
  583633
  592054
  592364
  608606
  610365
  623950
  623958
  624285
  653261
  654385
  671703
  676927
  676929
  679702
  684572
  685612
  687138
  689591
  689846
  691358
  700805
  714404
  722810
  732379
  735684
  738907
  740235
  744460
  744469
  744631
  758812
  758980
  759782
  765482
  779532
  794425
  797499
  800069
  800114
  800127
  800268
  800324
  801243
  801905
  807806
  815790
  817486
  818326
  818362
  824332
  825002
  825204
]
15.64 ms
(8.36%)
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
  676929
  685612
  687138
  623950
  758812
  779532
  387487
  408060
  387006
  426894
  758980
  447493
  817486
  402604
  185208
  389304
  486924
  506960
  689846
  654385
  800324
  735684
  800114
  807806
  390219
  185212
  390698
  653261
  592054
  759782
  765482
  427925
  323129
  406235
  75664
  391677
  525251
  824332
  825204
  801243
  801905
  379578
  386071
  185011
  583633
  700805
  714404
  608606
  610365
  744460
  744469
  744631
  185708
  448652
  412222
  501720
  185834
  357806
  389135
  400435
  514568
  679702
  592364
  623958
  357886
  424571
  404032
  825002
  815790
  800127
  390200
  185428
  389142
  408172
  684572
  691358
  624285
  797499
  732379
  800069
  385096
  384986
  390592
  494578
  382696
  402605
  818326
  722810
  800268
  740235
  738907
  738923
  794425
  390908
  76268
  563715
  671703
  689591
  555944
  562881
  572018
  391064
  402601
  152276
  401492
  415934
  501750
  523971
  818362
  184985
  408085
  569827
  185464
  501718
  511294
  676927
  413300
  185606
  185861
  319841
]
2.48 ms
(1.33%)
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
  75664
  76268
  152276
  184985
  185011
  185208
  185212
  185428
  185464
  185606
  185708
  185834
  185861
  319841
  323129
  357806
  357886
  379578
  382696
  384986
  385096
  386071
  387006
  387487
  389135
  389142
  389304
  390200
  390219
  390592
  390698
  390908
  391064
  391677
  400435
  401492
  402601
  402604
  402605
  404032
  406235
  408060
  408085
  408172
  412222
  413300
  415934
  424571
  426894
  427925
  447493
  448652
  486924
  494578
  501718
  501720
  501750
  506960
  511294
  514568
  523971
  525251
  555944
  562881
  563715
  569827
  572018
  583633
  592054
  592364
  608606
  610365
  623950
  623958
  624285
  653261
  654385
  671703
  676927
  676929
  679702
  684572
  685612
  687138
  689591
  689846
  691358
  700805
  714404
  722810
  732379
  735684
  738907
  740235
  744460
  744469
  744631
  758812
  758980
  759782
  765482
  779532
  794425
  797499
  800069
  800114
  800127
  800268
  800324
  801243
  801905
  807806
  815790
  817486
  818326
  818362
  824332
  825002
  825204
]
1.77 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy massage"
]
1.65 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy массаж"
]
1.55 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.37 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy массаж"
]

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.