GET https://search.jues.net/search/embeds/9?q=tiktok%20homemade

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
215.45 ms
(61.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "тикток социальн сет домашн любительск"
]
111.74 ms
(32.10%)
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
  712120
  718445
  729482
  729853
  730405
  732232
  732510
  732936
  732952
  733260
  733617
  734179
  734592
  735069
  735230
  735439
  735735
  739662
  739711
  741144
  741513
  742705
  742815
  743488
  743511
  743569
  743700
  744024
  744345
  744523
  746184
  746195
  746919
  747225
  747232
  748850
  749747
  750150
  751950
  752025
  752259
  753128
  754177
  754729
  757264
  757844
  759024
  759222
  759244
  761937
  762211
  762387
  762631
  762845
  763215
  763807
  763831
  763938
  764550
  764911
  765631
  765980
  766125
  766451
  766906
  766962
  768627
  769215
  769651
  770052
  771233
  778284
  778443
  778489
  779225
  780861
  782336
  782815
  784872
  786092
  786262
  787262
  788732
  788733
  789501
  789576
  790266
  794764
  794948
  795097
  797078
  797475
  798692
  805244
  816174
  818312
  819364
  819755
  819885
  821790
  821805
  824246
  824739
  824907
  825330
  825372
  825374
  825408
  825520
  826699
  826717
  826899
  827199
  827277
  827503
]
11.94 ms
(3.43%)
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
  739662
  748850
  752025
  751950
  754177
  763807
  797475
  729482
  763831
  797078
  778284
  789576
  786092
  819364
  816174
  819755
  819885
  821805
  825983
  826699
  825520
  826717
  818312
  821790
  825408
  827199
  827277
  827503
  825372
  825374
  824739
  824907
  825330
  825336
  824246
  826899
  718445
  712120
  778443
  784872
  786262
  788732
  794764
  794948
  798692
  805244
  778489
  779225
  780861
  782336
  782815
  788733
  790266
  795097
  729853
  733260
  733617
  734179
  734592
  741144
  742815
  744345
  746184
  749747
  757264
  759024
  762631
  766451
  769215
  787262
  789501
  730405
  732232
  739711
  741513
  743488
  744523
  759244
  761937
  762211
  768627
  732936
  732952
  734751
  735230
  735439
  735735
  743511
  746195
  747225
  747232
  750150
  753128
  763938
  764550
  770052
  771233
  744024
  752259
  757844
  759222
  762387
  762845
  763215
  764465
  765980
  766906
  766962
  769651
  732510
  735069
  742705
  743569
  743700
  746919
  754729
  763261
  764911
  765631
  766125
]
2.92 ms
(0.84%)
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
  712120
  718445
  729482
  729853
  730405
  732232
  732510
  732936
  732952
  733260
  733617
  734179
  734592
  735069
  735230
  735439
  735735
  739662
  739711
  741144
  741513
  742705
  742815
  743488
  743511
  743569
  743700
  744024
  744345
  744523
  746184
  746195
  746919
  747225
  747232
  748850
  749747
  750150
  751950
  752025
  752259
  753128
  754177
  754729
  757264
  757844
  759024
  759222
  759244
  761937
  762211
  762387
  762631
  762845
  763215
  763807
  763831
  763938
  764550
  764911
  765631
  765980
  766125
  766451
  766906
  766962
  768627
  769215
  769651
  770052
  771233
  778284
  778443
  778489
  779225
  780861
  782336
  782815
  784872
  786092
  786262
  787262
  788732
  788733
  789501
  789576
  790266
  794764
  794948
  795097
  797078
  797475
  798692
  805244
  816174
  818312
  819364
  819755
  819885
  821790
  821805
  824246
  824739
  824907
  825330
  825372
  825374
  825408
  825520
  826699
  826717
  826899
  827199
  827277
  827503
]
2.36 ms
(0.68%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.25 ms
(0.65%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "tiktok homemade"
]
1.48 ms
(0.43%)
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.