GET https://search.jues.net/search/embeds/7?q=tiktok%20%D0%BF%D0%BE%D1%80%D0%BD%D0%BE

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
187.42 ms
(90.47%)
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
  418381
  466777
  503536
  529674
  532592
  532614
  537487
  542002
  542907
  558182
  567800
  573212
  639516
  640346
  684731
  694789
  703675
  707843
  713727
  715244
  715810
  716512
  723208
  726126
  726281
  730161
  730413
  732672
  733213
  735478
  736681
  739167
  739190
  746734
  748065
  752110
  753961
  755043
  757499
  760347
  760384
  761315
  762630
  763016
  763086
  763247
  764908
  765962
  774648
  777328
  778528
  782033
  782034
  782289
  782384
  783479
  785048
  787257
  788341
  789555
  790054
  790089
  790098
  794054
  797099
  799678
  811752
  812244
  814272
  814411
  814418
  814455
  814729
  816093
  816171
  816172
  816175
  817389
  818265
  818708
  821803
  821822
  823893
  823900
  824186
  824383
  824726
  825211
  825334
  825990
  826342
  826491
  826494
  826515
  827057
  827124
  827525
  827757
  828017
  828108
  828121
  828127
  828169
  828231
  828235
  828237
  828240
  828290
  828354
  828403
  828473
]
9.97 ms
(4.81%)
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
  824383
  824625
  824821
  825211
  826515
  817389
  824074
  825990
  826068
  827057
  827124
  825334
  826342
  826420
  828127
  828231
  828240
  828169
  824186
  828121
  827757
  716512
  797099
  777328
  782289
  790098
  739167
  760384
  764908
  763247
  732672
  757499
  763016
  765962
  730161
  774648
  782034
  787257
  790054
  794054
  812244
  418381
  466777
  529674
  503536
  532614
  542002
  537487
  542907
  573212
  532592
  816175
  818265
  823785
  823900
  826491
  816093
  823893
  827525
  818708
  821803
  821822
  825655
  825666
  826494
  816171
  816172
  824726
  828290
  828108
  828403
  828237
  828354
  828235
  828017
  828473
  703675
  723208
  782033
  778528
  799678
  730413
  762630
  785048
  788341
  790089
  811752
  726126
  726281
  736681
  748065
  763086
  755043
  761315
  764866
  733213
  735478
  746734
  752110
  753961
  760347
  739190
  789555
  814418
  814272
  814455
  814411
  814729
  558182
  567800
  713727
  715810
  684731
  694789
  707843
  715244
  640346
  639516
  782384
  783479
]
3.09 ms
(1.49%)
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
  418381
  466777
  503536
  529674
  532592
  532614
  537487
  542002
  542907
  558182
  567800
  573212
  639516
  640346
  684731
  694789
  703675
  707843
  713727
  715244
  715810
  716512
  723208
  726126
  726281
  730161
  730413
  732672
  733213
  735478
  736681
  739167
  739190
  746734
  748065
  752110
  753961
  755043
  757499
  760347
  760384
  761315
  762630
  763016
  763086
  763247
  764908
  765962
  774648
  777328
  778528
  782033
  782034
  782289
  782384
  783479
  785048
  787257
  788341
  789555
  790054
  790089
  790098
  794054
  797099
  799678
  811752
  812244
  814272
  814411
  814418
  814455
  814729
  816093
  816171
  816172
  816175
  817389
  818265
  818708
  821803
  821822
  823893
  823900
  824186
  824383
  824726
  825211
  825334
  825990
  826342
  826491
  826494
  826515
  827057
  827124
  827525
  827757
  828017
  828108
  828121
  828127
  828169
  828231
  828235
  828237
  828240
  828290
  828354
  828403
  828473
]
2.16 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "tiktok порно"
]
1.65 ms
(0.80%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.76%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "тикток социальн сет порн"
]
1.28 ms
(0.62%)
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.