GET https://search.jues.net/search/embeds/7?q=beauty%20ass

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
246.14 ms
(86.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
  418445
  420008
  424527
  425105
  431691
  437314
  442196
  442234
  442257
  442285
  454878
  459042
  463630
  464388
  464476
  465487
  472544
  477335
  480372
  480417
  481794
  485449
  486400
  488033
  488359
  490608
  490704
  492319
  496516
  499701
  504411
  508593
  510951
  511804
  512030
  512560
  512582
  512919
  513155
  513156
  513427
  513619
  514279
  514423
  514811
  515038
  515350
  515413
  515544
  515601
  515659
  516059
  516417
  516466
  517153
  517652
  518143
  518220
  518781
  519161
  519878
  520005
  520029
  520191
  520407
  520562
  520673
  521244
  521324
  522776
  522927
  523045
  524296
  524682
  525154
  526290
  526531
  527180
  527249
  527442
  529975
  530870
  531468
  531776
  532079
  533137
  533433
  536728
  538915
  538936
  539955
  543387
  544347
  547679
  547797
  547800
  561171
  568455
  574441
  578703
  579484
  583668
  586792
  588991
  602594
  602610
  611339
  613185
  613263
  613819
  622041
  626546
  626849
  640152
  648466
  669218
  682222
  738291
  748422
  775679
]
25.36 ms
(8.94%)
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
  536728
  520029
  464476
  518143
  481794
  464388
  496516
  529975
  533433
  538936
  515038
  515413
  530870
  544347
  579484
  547797
  547800
  669218
  574441
  640152
  626546
  480417
  442234
  431691
  459042
  420008
  442285
  512030
  513619
  516417
  516466
  518781
  520191
  520562
  520673
  521324
  511804
  512582
  522927
  490704
  513156
  514279
  519878
  515350
  561171
  514423
  499701
  513427
  425105
  454878
  519161
  682222
  626849
  437314
  512560
  418445
  488359
  531776
  512919
  516059
  508593
  522776
  532079
  538915
  472544
  648466
  547679
  463630
  442196
  527249
  514811
  527180
  539955
  583668
  521244
  490608
  602594
  524296
  513155
  480372
  527442
  492319
  520407
  611339
  518220
  586792
  531468
  613185
  517153
  510951
  568455
  578703
  613263
  533137
  526531
  424527
  488033
  515601
  524682
  515659
  520005
  477335
  515544
  588991
  613819
  465487
  622041
  602610
  543387
  442257
  525154
  523045
  517652
  504411
  485449
  486400
  526290
  775679
  738291
  748422
]
4.43 ms
(1.56%)
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
  418445
  420008
  424527
  425105
  431691
  437314
  442196
  442234
  442257
  442285
  454878
  459042
  463630
  464388
  464476
  465487
  472544
  477335
  480372
  480417
  481794
  485449
  486400
  488033
  488359
  490608
  490704
  492319
  496516
  499701
  504411
  508593
  510951
  511804
  512030
  512560
  512582
  512919
  513155
  513156
  513427
  513619
  514279
  514423
  514811
  515038
  515350
  515413
  515544
  515601
  515659
  516059
  516417
  516466
  517153
  517652
  518143
  518220
  518781
  519161
  519878
  520005
  520029
  520191
  520407
  520562
  520673
  521244
  521324
  522776
  522927
  523045
  524296
  524682
  525154
  526290
  526531
  527180
  527249
  527442
  529975
  530870
  531468
  531776
  532079
  533137
  533433
  536728
  538915
  538936
  539955
  543387
  544347
  547679
  547797
  547800
  561171
  568455
  574441
  578703
  579484
  583668
  586792
  588991
  602594
  602610
  611339
  613185
  613263
  613819
  622041
  626546
  626849
  640152
  648466
  669218
  682222
  738291
  748422
  775679
]
2.41 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "beauty жоп"
]
1.79 ms
(0.63%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(0.63%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "beauty жоп"
]
1.67 ms
(0.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beauty ass"
]

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.