Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
328.41 ms
(92.71%)
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
  114672
  213057
  286475
  365938
  382371
  383495
  385304
  387186
  388789
  389412
  390519
  390701
  395839
  395856
  395999
  402008
  402557
  403216
  405000
  405145
  407058
  410753
  410855
  413000
  421839
  422629
  424505
  429814
  430048
  430833
  434456
  443609
  445681
  454994
  463082
  470344
  473589
  485786
  486130
  486283
  486589
  487424
  488585
  489674
  491200
  494266
  495231
  495835
  499498
  504209
  506841
  510287
  514815
  515136
  516007
  525946
  536649
  541625
  544255
  550093
  552005
  552018
  552120
  558353
  558572
  559140
  560201
  560209
  560212
  561107
  571458
  574776
  575472
  590881
  597186
  597923
  598111
  598279
  601063
  604060
  613864
  615574
  622131
  622229
  623912
  640614
  640721
  645999
  646214
  649622
  664845
  672099
  672184
  682497
  682599
  684326
  686021
  719289
  723529
  730937
  731777
  742604
  742906
  748363
  760834
  767957
  783790
  786039
  787912
  792486
  793406
  803341
  804943
  807192
  816394
  816758
  820152
  821605
  822491
  823205
]
16.53 ms
(4.67%)
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
  558353
  424505
  430833
  664845
  682599
  410855
  213057
  390701
  672184
  686021
  807192
  510287
  731777
  387186
  672099
  598111
  792486
  793406
  365938
  286475
  385304
  783790
  786039
  787912
  742906
  760834
  558572
  742604
  382371
  767957
  390519
  395856
  454994
  525946
  473589
  491200
  820152
  552005
  403216
  405000
  571458
  410753
  597923
  407058
  623912
  804943
  495231
  421839
  499498
  682497
  640614
  383495
  622229
  803341
  486283
  574776
  443609
  429814
  488585
  494266
  388789
  552018
  422629
  822491
  723529
  816394
  816758
  544255
  719289
  748363
  730937
  434456
  536649
  504209
  559140
  560201
  405145
  515136
  684326
  430048
  640721
  506841
  541625
  560209
  561107
  597186
  615574
  598279
  487424
  402557
  590881
  495835
  402008
  485786
  622131
  613864
  389412
  821605
  550093
  489674
  560212
  601063
  514815
  395839
  395999
  575472
  646214
  645999
  823205
  486589
  552120
  470344
  516007
  649622
  445681
  114672
  413000
  463082
  604060
  486130
]
2.79 ms
(0.79%)
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
  114672
  213057
  286475
  365938
  382371
  383495
  385304
  387186
  388789
  389412
  390519
  390701
  395839
  395856
  395999
  402008
  402557
  403216
  405000
  405145
  407058
  410753
  410855
  413000
  421839
  422629
  424505
  429814
  430048
  430833
  434456
  443609
  445681
  454994
  463082
  470344
  473589
  485786
  486130
  486283
  486589
  487424
  488585
  489674
  491200
  494266
  495231
  495835
  499498
  504209
  506841
  510287
  514815
  515136
  516007
  525946
  536649
  541625
  544255
  550093
  552005
  552018
  552120
  558353
  558572
  559140
  560201
  560209
  560212
  561107
  571458
  574776
  575472
  590881
  597186
  597923
  598111
  598279
  601063
  604060
  613864
  615574
  622131
  622229
  623912
  640614
  640721
  645999
  646214
  649622
  664845
  672099
  672184
  682497
  682599
  684326
  686021
  719289
  723529
  730937
  731777
  742604
  742906
  748363
  760834
  767957
  783790
  786039
  787912
  792486
  793406
  803341
  804943
  807192
  816394
  816758
  820152
  821605
  822491
  823205
]
1.86 ms
(0.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "жмж куни худые"
]
1.70 ms
(0.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жмж секс втро куннилингус оральн секс худые"
]
1.55 ms
(0.44%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.40 ms
(0.40%)
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.