GET https://search.jues.net/search/embeds/9?q=office%20girl

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.01 ms
(85.53%)
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
  13075
  89205
  161581
  181569
  182221
  208504
  288045
  301402
  386388
  387507
  389832
  395670
  405191
  418843
  420023
  466468
  468912
  478403
  488306
  491922
  491972
  492514
  514687
  515617
  517952
  518307
  536012
  540501
  542015
  544259
  548313
  549878
  550172
  556759
  557251
  558369
  559593
  559918
  563494
  563512
  563522
  565970
  567732
  570786
  570844
  585520
  587541
  587831
  592428
  592514
  594804
  594805
  596247
  600818
  613610
  613865
  619459
  620989
  623557
  624899
  625942
  632729
  661908
  670496
  671546
  673835
  678837
  678842
  689860
  689898
  690126
  694122
  698454
  699005
  699359
  702188
  703522
  706311
  706513
  708494
  708839
  715194
  715332
  718407
  718755
  718851
  722673
  735828
  741057
  741470
  741606
  743089
  743147
  744093
  751631
  752951
  755760
  760688
  767960
  770671
  772694
  774211
  778716
  780843
  783699
  787745
  799044
  799058
  799625
  805195
  807492
  814462
  815085
  815103
  815125
  816554
  820601
  823305
  823360
]
12.78 ms
(8.35%)
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
  514687
  517952
  515617
  405191
  468912
  559918
  491922
  491972
  466468
  518307
  559593
  708494
  715194
  690126
  706311
  619459
  743089
  743147
  718755
  418843
  420023
  815085
  820601
  815103
  540501
  557251
  550172
  678837
  689898
  673835
  718407
  671546
  715332
  585520
  587831
  624899
  799625
  778716
  759378
  744093
  741470
  760688
  703522
  718851
  395670
  807492
  386388
  208504
  161581
  301402
  89205
  823305
  816554
  492514
  544259
  549878
  556759
  567732
  548313
  563512
  702188
  661908
  706513
  670496
  699005
  708839
  570786
  570844
  594805
  613610
  592428
  594804
  596247
  620989
  623557
  625942
  632729
  587541
  600818
  741606
  772694
  783699
  787745
  735828
  751631
  752951
  755760
  741057
  478403
  814462
  815125
  565970
  689860
  563522
  613865
  799044
  780843
  770671
  799058
  805195
  182221
  774211
  694122
  488306
  699359
  767960
  722673
  592514
  181569
  288045
  13075
  389832
  387507
  823360
  536012
  542015
  558369
  563494
  678842
  698454
]
2.63 ms
(1.72%)
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
  13075
  89205
  161581
  181569
  182221
  208504
  288045
  301402
  386388
  387507
  389832
  395670
  405191
  418843
  420023
  466468
  468912
  478403
  488306
  491922
  491972
  492514
  514687
  515617
  517952
  518307
  536012
  540501
  542015
  544259
  548313
  549878
  550172
  556759
  557251
  558369
  559593
  559918
  563494
  563512
  563522
  565970
  567732
  570786
  570844
  585520
  587541
  587831
  592428
  592514
  594804
  594805
  596247
  600818
  613610
  613865
  619459
  620989
  623557
  624899
  625942
  632729
  661908
  670496
  671546
  673835
  678837
  678842
  689860
  689898
  690126
  694122
  698454
  699005
  699359
  702188
  703522
  706311
  706513
  708494
  708839
  715194
  715332
  718407
  718755
  718851
  722673
  735828
  741057
  741470
  741606
  743089
  743147
  744093
  751631
  752951
  755760
  760688
  767960
  770671
  772694
  774211
  778716
  780843
  783699
  787745
  799044
  799058
  799625
  805195
  807492
  814462
  815085
  815103
  815125
  816554
  820601
  823305
  823360
]
1.98 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "office girl"
]
1.87 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секретарш девушк"
]
1.52 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(0.90%)
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.