GET https://search.jues.net/search/embeds/7?q=webcam%20skinny

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
218.09 ms
(89.89%)
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
  373859
  398848
  403252
  412134
  420858
  421391
  423619
  439887
  448571
  453863
  463293
  473193
  475597
  477146
  477249
  483043
  484066
  488757
  489067
  494108
  499715
  502772
  505328
  507356
  507404
  509426
  509441
  509443
  509446
  509456
  509459
  509514
  510019
  518921
  521332
  530422
  536173
  538556
  539092
  540158
  540698
  540857
  541726
  541932
  542136
  542335
  542776
  544106
  546324
  547163
  547377
  549616
  551774
  553192
  555883
  556197
  557553
  558407
  558925
  560074
  560751
  561811
  568296
  568817
  568869
  569372
  569812
  579712
  581743
  647228
  648615
  653322
  656909
  661546
  666455
  672727
  675884
  679533
  680788
  690933
  693795
  708562
  713157
  720133
  814059
  814067
  814127
  816117
  817031
  817374
  817820
  818126
  819531
  819973
  823257
  823352
  823353
  823505
  823954
  824234
  824235
  824397
  825023
  825033
  825095
  825246
  825921
  826266
  826528
  826564
  826630
  826674
  826850
  826852
  827167
  827228
  828395
  828847
]
15.60 ms
(6.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
  439887
  463293
  477146
  477249
  412134
  420858
  421391
  448571
  475597
  502772
  509426
  509446
  509459
  488757
  489067
  494108
  507404
  509441
  509443
  509456
  483043
  499715
  505328
  521332
  423619
  581743
  473193
  484066
  518921
  373859
  398848
  403252
  817820
  824234
  825023
  825095
  540857
  826528
  826674
  826564
  826630
  814127
  817031
  817374
  818126
  819973
  823257
  823683
  823954
  826266
  826852
  826850
  827167
  827228
  823353
  823505
  824235
  825928
  814059
  814067
  816117
  819531
  823352
  824397
  825033
  825246
  828395
  828847
  825921
  453863
  507356
  509514
  539092
  540158
  510019
  538556
  540698
  536173
  530422
  546324
  547377
  549616
  557553
  558407
  569372
  541932
  542335
  542776
  544106
  547163
  553192
  556197
  558925
  560074
  561811
  579712
  541726
  542136
  551774
  555883
  560751
  568296
  568817
  568869
  569812
  666455
  675884
  679533
  680788
  690933
  708562
  647228
  648615
  653322
  656909
  661546
  672727
  693795
  713157
  720133
]
2.53 ms
(1.04%)
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
  373859
  398848
  403252
  412134
  420858
  421391
  423619
  439887
  448571
  453863
  463293
  473193
  475597
  477146
  477249
  483043
  484066
  488757
  489067
  494108
  499715
  502772
  505328
  507356
  507404
  509426
  509441
  509443
  509446
  509456
  509459
  509514
  510019
  518921
  521332
  530422
  536173
  538556
  539092
  540158
  540698
  540857
  541726
  541932
  542136
  542335
  542776
  544106
  546324
  547163
  547377
  549616
  551774
  553192
  555883
  556197
  557553
  558407
  558925
  560074
  560751
  561811
  568296
  568817
  568869
  569372
  569812
  579712
  581743
  647228
  648615
  653322
  656909
  661546
  666455
  672727
  675884
  679533
  680788
  690933
  693795
  708562
  713157
  720133
  814059
  814067
  814127
  816117
  817031
  817374
  817820
  818126
  819531
  819973
  823257
  823352
  823353
  823505
  823954
  824234
  824235
  824397
  825023
  825033
  825095
  825246
  825921
  826266
  826528
  826564
  826630
  826674
  826850
  826852
  827167
  827228
  828395
  828847
]
1.80 ms
(0.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam skinny"
]
1.67 ms
(0.69%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вебкамер худые"
]
1.56 ms
(0.64%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.37 ms
(0.56%)
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.