GET https://search.jues.net/search/embeds/3?q=pov%20domina

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.70 ms
(84.80%)
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
  391372
  393342
  396100
  416928
  417799
  418974
  421571
  421621
  425744
  426076
  427388
  429665
  433436
  434609
  436848
  437232
  441269
  441476
  450910
  450966
  451907
  459364
  463026
  463183
  463197
  468462
  469191
  474933
  476780
  477393
  477401
  477414
  478431
  479295
  480976
  481792
  482623
  483124
  483593
  484023
  487864
  489931
  494379
  495930
  496237
  496686
  498773
  499034
  499149
  499617
  499693
  500129
  500824
  501968
  502019
  503812
  506014
  509322
  511337
  511348
  511596
  514055
  514136
  514364
  516438
  519691
  522239
  523321
  524207
  524327
  525273
  525418
  525994
  526233
  527110
  527668
  533192
  533261
  538077
  538544
  541767
  542182
  542387
  542412
  545675
  545725
  548117
  548897
  551457
  552544
  553946
  554782
  555882
  562211
  569568
  587951
  597169
  604329
  610228
  615177
  615415
  618673
  620244
  621387
  633215
  633689
  640592
  641778
  649622
  650636
  662900
  736265
  746722
  756493
  761746
  767508
  771213
  772964
  773524
  781164
]
15.04 ms
(9.06%)
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
  542412
  553946
  562211
  542182
  542387
  554782
  649622
  650636
  551457
  597169
  641778
  604329
  633215
  736265
  746722
  761746
  773524
  771213
  767508
  615177
  463197
  417799
  421571
  421621
  426076
  434609
  477393
  477401
  478431
  480976
  418974
  441476
  499617
  502019
  506014
  511337
  524207
  489931
  527668
  548897
  662900
  772964
  499034
  620244
  391372
  459364
  481792
  524327
  527110
  545725
  509322
  499149
  483593
  640592
  756493
  396100
  433436
  416928
  441269
  451907
  469191
  476780
  487864
  501968
  511348
  525418
  522239
  498773
  503812
  525273
  496686
  516438
  538077
  477414
  545675
  569568
  548117
  552544
  555882
  621387
  615415
  610228
  587951
  618673
  781164
  633689
  427388
  436848
  474933
  479295
  463026
  425744
  463183
  468462
  429665
  437232
  499693
  500129
  500824
  519691
  483124
  495930
  514055
  526233
  541767
  484023
  511596
  538544
  496237
  514364
  523321
  525994
  482623
  533192
  533261
  494379
  393342
  450910
  450966
  514136
]
2.91 ms
(1.76%)
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
  391372
  393342
  396100
  416928
  417799
  418974
  421571
  421621
  425744
  426076
  427388
  429665
  433436
  434609
  436848
  437232
  441269
  441476
  450910
  450966
  451907
  459364
  463026
  463183
  463197
  468462
  469191
  474933
  476780
  477393
  477401
  477414
  478431
  479295
  480976
  481792
  482623
  483124
  483593
  484023
  487864
  489931
  494379
  495930
  496237
  496686
  498773
  499034
  499149
  499617
  499693
  500129
  500824
  501968
  502019
  503812
  506014
  509322
  511337
  511348
  511596
  514055
  514136
  514364
  516438
  519691
  522239
  523321
  524207
  524327
  525273
  525418
  525994
  526233
  527110
  527668
  533192
  533261
  538077
  538544
  541767
  542182
  542387
  542412
  545675
  545725
  548117
  548897
  551457
  552544
  553946
  554782
  555882
  562211
  569568
  587951
  597169
  604329
  610228
  615177
  615415
  618673
  620244
  621387
  633215
  633689
  640592
  641778
  649622
  650636
  662900
  736265
  746722
  756493
  761746
  767508
  771213
  772964
  773524
  781164
]
1.97 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.87 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов доминирован"
]
1.77 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "пов доминирован"
]
1.67 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov domina"
]

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.