GET https://search.jues.net/search/embeds/6?q=russian%20girls

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.67 ms
(84.65%)
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
  34296
  389590
  396354
  402904
  404267
  415835
  423828
  423909
  437522
  443569
  444035
  444253
  448340
  448737
  449590
  451585
  452675
  454155
  454660
  455328
  457325
  458160
  459449
  460509
  461396
  462176
  462506
  463304
  464573
  465754
  466424
  466453
  466854
  467814
  468438
  469776
  470129
  470530
  470828
  470878
  471331
  474067
  474210
  474990
  475216
  476728
  481213
  481483
  482601
  483221
  484550
  486465
  488651
  488966
  490599
  491046
  491971
  495547
  501669
  502192
  507278
  508015
  508738
  511227
  511547
  511740
  512143
  513391
  514000
  514960
  516802
  517692
  517957
  519787
  521981
  523302
  524541
  541245
  542392
  544041
  548263
  550239
  551198
  551260
  551570
  553240
  557363
  558876
  560662
  561001
  561151
  561270
  561679
  561721
  563750
  564999
  565589
  565818
  567695
  567741
  568814
  571615
  571654
  571906
  572521
  573116
  573624
  573945
  574798
  574843
  575500
  578972
  581617
  586466
  595378
  597018
  597561
  598027
  599939
  600362
]
15.08 ms
(9.34%)
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
  470878
  415835
  462176
  511227
  513391
  514000
  519787
  551570
  461396
  471331
  600362
  599939
  459449
  467814
  389590
  470828
  437522
  444253
  474990
  466854
  501669
  491046
  423909
  567741
  560662
  551198
  597561
  455328
  475216
  404267
  465754
  502192
  486465
  512143
  517957
  490599
  34296
  470129
  463304
  567695
  551260
  561721
  573624
  561270
  565589
  598027
  462506
  423828
  469776
  448340
  449590
  454155
  474210
  514960
  524541
  507278
  521981
  483221
  523302
  491971
  495547
  595378
  597018
  444035
  482601
  476728
  488651
  460509
  464573
  488966
  557363
  558876
  565818
  571615
  572521
  542392
  544041
  568814
  571654
  573116
  581617
  548263
  561001
  561151
  561679
  563750
  564999
  573945
  578972
  550239
  553240
  571906
  574798
  574843
  575500
  586466
  457325
  466424
  402904
  481483
  451585
  452675
  466453
  474067
  396354
  448737
  454660
  468438
  443569
  458160
  470530
  481213
  511547
  508738
  516802
  517692
  541245
  484550
  508015
  511740
]
2.63 ms
(1.63%)
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
  34296
  389590
  396354
  402904
  404267
  415835
  423828
  423909
  437522
  443569
  444035
  444253
  448340
  448737
  449590
  451585
  452675
  454155
  454660
  455328
  457325
  458160
  459449
  460509
  461396
  462176
  462506
  463304
  464573
  465754
  466424
  466453
  466854
  467814
  468438
  469776
  470129
  470530
  470828
  470878
  471331
  474067
  474210
  474990
  475216
  476728
  481213
  481483
  482601
  483221
  484550
  486465
  488651
  488966
  490599
  491046
  491971
  495547
  501669
  502192
  507278
  508015
  508738
  511227
  511547
  511740
  512143
  513391
  514000
  514960
  516802
  517692
  517957
  519787
  521981
  523302
  524541
  541245
  542392
  544041
  548263
  550239
  551198
  551260
  551570
  553240
  557363
  558876
  560662
  561001
  561151
  561270
  561679
  561721
  563750
  564999
  565589
  565818
  567695
  567741
  568814
  571615
  571654
  571906
  572521
  573116
  573624
  573945
  574798
  574843
  575500
  578972
  581617
  586466
  595378
  597018
  597561
  598027
  599939
  600362
]
2.12 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian girls"
]
1.73 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск девушк"
]
1.71 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(0.94%)
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.