GET https://search.jues.net/search/embeds/10?q=webcam%20mother

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.08 ms
(83.97%)
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
  385955
  388711
  389495
  391512
  392213
  396331
  398565
  402631
  411213
  411382
  412827
  417836
  423819
  424114
  426213
  428611
  431639
  432688
  433418
  435552
  435600
  439643
  440902
  441158
  441203
  443257
  444431
  447238
  450262
  452982
  454767
  455940
  456130
  456701
  457233
  459470
  460207
  461956
  462557
  464035
  465460
  468142
  468165
  468869
  469139
  469260
  470064
  470493
  471051
  473261
  473326
  477081
  478148
  478992
  479530
  480497
  484947
  484957
  485962
  486270
  488238
  490449
  492403
  493401
  493581
  493752
  494547
  494598
  496011
  496091
  502660
  502767
  503738
  508382
  511375
  516807
  525910
  526449
  530688
  555039
  555046
  555242
  555287
  556550
  558121
  573519
  577949
  579249
  579587
  580025
  586583
  590373
  599714
  602591
  621229
  665960
  672105
  720171
  726980
  727735
  727810
  728255
  750301
  759009
  759756
  759939
  761017
  768330
  769894
  773352
  794098
  794866
  795313
  796043
  796106
  796160
  801264
  801426
  814343
]
13.71 ms
(9.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
  794098
  796043
  801426
  391512
  411382
  424114
  428611
  441158
  417836
  440902
  469260
  452982
  457233
  460207
  486270
  526449
  577949
  599714
  796106
  795313
  801264
  759756
  773352
  728255
  750301
  796160
  473261
  411213
  479530
  432688
  456701
  469139
  470493
  412827
  493401
  443257
  468165
  441203
  470064
  493581
  727810
  388711
  602591
  814343
  530688
  508382
  555287
  555242
  580025
  665960
  672105
  621229
  794866
  727735
  759009
  759939
  769894
  768330
  726980
  761017
  720171
  485962
  385955
  402631
  423819
  431639
  433418
  444431
  426213
  454767
  459470
  468869
  456130
  447238
  450262
  464035
  488238
  494547
  503738
  471051
  579587
  556550
  558121
  389495
  455940
  435552
  435600
  473326
  461956
  478148
  478992
  490449
  492403
  502660
  525910
  484947
  494598
  484957
  496011
  496091
  465460
  392213
  396331
  477081
  493752
  555046
  586583
  590373
  480497
  462557
  511375
  579249
  398565
  761714
  439643
  468142
  502767
  516807
  555039
  573519
]
3.00 ms
(2.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
  385955
  388711
  389495
  391512
  392213
  396331
  398565
  402631
  411213
  411382
  412827
  417836
  423819
  424114
  426213
  428611
  431639
  432688
  433418
  435552
  435600
  439643
  440902
  441158
  441203
  443257
  444431
  447238
  450262
  452982
  454767
  455940
  456130
  456701
  457233
  459470
  460207
  461956
  462557
  464035
  465460
  468142
  468165
  468869
  469139
  469260
  470064
  470493
  471051
  473261
  473326
  477081
  478148
  478992
  479530
  480497
  484947
  484957
  485962
  486270
  488238
  490449
  492403
  493401
  493581
  493752
  494547
  494598
  496011
  496091
  502660
  502767
  503738
  508382
  511375
  516807
  525910
  526449
  530688
  555039
  555046
  555242
  555287
  556550
  558121
  573519
  577949
  579249
  579587
  580025
  586583
  590373
  599714
  602591
  621229
  665960
  672105
  720171
  726980
  727735
  727810
  728255
  750301
  759009
  759756
  759939
  761017
  768330
  769894
  773352
  794098
  794866
  795313
  796043
  796106
  796160
  801264
  801426
  814343
]
2.05 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam mother"
]
1.66 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вебкамер мам женщин"
]
1.52 ms
(1.03%)
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.