GET https://search.jues.net/search/embeds/9?q=big%20ass%20girls

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
196.22 ms
(86.06%)
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
  398104
  400599
  412725
  413341
  413418
  441535
  444446
  446650
  448006
  465720
  466427
  467099
  493813
  494919
  500958
  513136
  523244
  524988
  525987
  538750
  546516
  572912
  577341
  582438
  588203
  588939
  589414
  591420
  592289
  595283
  597460
  600660
  601391
  602316
  604265
  605692
  609081
  614601
  615260
  616653
  617230
  619611
  620716
  622951
  624405
  631579
  634346
  636063
  636628
  638159
  646230
  650139
  656891
  662134
  669303
  671342
  680298
  680777
  691928
  693254
  703944
  713895
  716118
  722369
  723300
  723537
  723750
  724739
  726972
  734541
  738645
  740172
  742321
  742738
  744187
  744450
  749486
  749865
  750248
  750368
  750620
  752359
  753150
  754313
  756680
  757267
  758382
  759621
  759959
  761861
  767414
  767470
  768103
  773736
  776317
  782452
  783988
  784425
  788661
  789624
  791422
  791557
  794909
  796463
  796673
  797356
  797792
  798429
  801553
  804408
  804847
  806158
  807157
  807902
  808267
  808917
  809826
  814525
]
22.89 ms
(10.04%)
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
  723300
  601391
  609081
  636628
  589414
  600660
  634346
  588203
  631579
  789624
  791557
  801553
  788661
  804408
  808267
  809826
  750620
  758382
  759959
  773736
  784425
  794909
  724739
  761861
  723750
  740172
  767470
  742738
  749865
  750368
  767414
  768103
  602316
  615260
  713895
  791422
  806158
  577341
  582438
  538750
  753150
  807902
  446650
  650139
  604265
  646230
  597460
  763882
  766674
  398104
  742321
  744450
  656891
  669303
  636063
  614601
  796463
  749486
  752359
  620716
  804847
  467099
  756680
  572912
  412725
  413341
  782452
  796673
  622951
  757267
  754313
  546516
  671342
  444446
  734541
  525987
  738645
  797356
  448006
  493813
  465720
  513136
  494919
  716118
  662134
  617230
  808917
  524988
  523244
  588939
  638159
  413418
  605692
  750248
  624405
  726972
  814525
  466427
  693254
  776317
  807157
  744187
  400599
  723537
  691928
  680298
  616653
  592289
  619611
  783988
  759621
  441535
  500958
  680777
  703944
  722369
  591420
  595283
  797792
  798429
]
3.03 ms
(1.33%)
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
  398104
  400599
  412725
  413341
  413418
  441535
  444446
  446650
  448006
  465720
  466427
  467099
  493813
  494919
  500958
  513136
  523244
  524988
  525987
  538750
  546516
  572912
  577341
  582438
  588203
  588939
  589414
  591420
  592289
  595283
  597460
  600660
  601391
  602316
  604265
  605692
  609081
  614601
  615260
  616653
  617230
  619611
  620716
  622951
  624405
  631579
  634346
  636063
  636628
  638159
  646230
  650139
  656891
  662134
  669303
  671342
  680298
  680777
  691928
  693254
  703944
  713895
  716118
  722369
  723300
  723537
  723750
  724739
  726972
  734541
  738645
  740172
  742321
  742738
  744187
  744450
  749486
  749865
  750248
  750368
  750620
  752359
  753150
  754313
  756680
  757267
  758382
  759621
  759959
  761861
  767414
  767470
  768103
  773736
  776317
  782452
  783988
  784425
  788661
  789624
  791422
  791557
  794909
  796463
  796673
  797356
  797792
  798429
  801553
  804408
  804847
  806158
  807157
  807902
  808267
  808917
  809826
  814525
]
1.56 ms
(0.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big ass girls"
]
1.55 ms
(0.68%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.40 ms
(0.61%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большая большие жоп девушк"
]
1.36 ms
(0.60%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.