GET https://search.jues.net/search/embeds/8?q=mother%20and%20guy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
218.71 ms
(86.63%)
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
  400991
  408074
  415286
  421564
  428531
  438284
  439651
  450872
  451486
  454179
  456611
  459457
  464374
  465628
  469469
  470017
  472898
  475180
  475198
  478719
  482383
  484596
  484905
  485484
  485869
  489938
  490884
  490885
  490931
  496057
  500459
  500581
  500994
  505968
  508734
  510389
  511218
  511281
  512042
  512433
  513095
  517277
  517650
  519169
  519173
  519651
  519721
  520902
  521770
  522423
  522489
  522825
  526697
  527014
  527754
  528608
  529940
  531061
  532509
  533130
  534672
  534968
  539224
  539906
  540343
  540622
  544202
  550976
  552852
  554302
  554434
  554768
  556674
  560548
  562773
  562895
  562935
  563125
  564369
  565534
  566563
  568167
  569068
  575703
  577349
  580368
  581348
  581566
  583246
  583247
  586356
  591285
  592210
  596517
  598279
  599631
  603241
  603778
  605213
  606596
  616521
  623444
  624936
  663429
  663498
  663926
  665193
  669679
  678960
  688003
  708034
  721537
  730722
  759554
  771936
  775974
  790302
  792652
  795123
  822946
]
23.75 ms
(9.41%)
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
  566563
  568167
  575703
  581566
  663429
  663498
  678960
  721537
  616521
  603778
  730722
  771936
  623444
  451486
  484905
  490884
  510389
  519173
  428531
  421564
  469469
  531061
  606596
  599631
  513095
  522423
  519721
  489938
  454179
  522489
  459457
  490931
  456611
  540622
  511281
  528608
  485869
  554768
  563125
  565534
  688003
  581348
  591285
  624936
  792652
  475180
  470017
  508734
  496057
  562895
  598279
  603241
  439651
  522825
  512433
  400991
  517650
  482383
  475198
  478719
  490885
  484596
  527014
  464374
  485484
  526697
  534672
  500994
  533130
  511218
  539224
  539906
  505968
  521770
  556674
  564369
  560548
  583246
  552852
  562935
  708034
  665193
  669679
  554302
  586356
  605213
  596517
  592210
  759554
  790302
  775974
  795123
  472898
  517277
  520902
  519651
  500581
  438284
  534968
  550976
  577349
  580368
  544202
  519169
  465628
  450872
  512042
  408074
  415286
  822946
  500459
  532509
  529940
  540343
  527754
  554434
  569068
  583247
  562773
  663926
]
3.00 ms
(1.19%)
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
  400991
  408074
  415286
  421564
  428531
  438284
  439651
  450872
  451486
  454179
  456611
  459457
  464374
  465628
  469469
  470017
  472898
  475180
  475198
  478719
  482383
  484596
  484905
  485484
  485869
  489938
  490884
  490885
  490931
  496057
  500459
  500581
  500994
  505968
  508734
  510389
  511218
  511281
  512042
  512433
  513095
  517277
  517650
  519169
  519173
  519651
  519721
  520902
  521770
  522423
  522489
  522825
  526697
  527014
  527754
  528608
  529940
  531061
  532509
  533130
  534672
  534968
  539224
  539906
  540343
  540622
  544202
  550976
  552852
  554302
  554434
  554768
  556674
  560548
  562773
  562895
  562935
  563125
  564369
  565534
  566563
  568167
  569068
  575703
  577349
  580368
  581348
  581566
  583246
  583247
  586356
  591285
  592210
  596517
  598279
  599631
  603241
  603778
  605213
  606596
  616521
  623444
  624936
  663429
  663498
  663926
  665193
  669679
  678960
  688003
  708034
  721537
  730722
  759554
  771936
  775974
  790302
  792652
  795123
  822946
]
1.98 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mother and guy"
]
1.79 ms
(0.71%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(0.71%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин guy"
]
1.44 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мам женщин guy"
]

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.