GET https://search.jues.net/search/embeds/4?q=camera%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
206.95 ms
(52.87%)
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
  383109
  396397
  397599
  410770
  413053
  418414
  418575
  422524
  427487
  430713
  431512
  432631
  437618
  437816
  440526
  440563
  441158
  443170
  445136
  449447
  449690
  453854
  455300
  455331
  456892
  456993
  457523
  458149
  461418
  462215
  463179
  467833
  473333
  475398
  475699
  476066
  476929
  477008
  481461
  481824
  483227
  484256
  490152
  490155
  491089
  492631
  492725
  494323
  495178
  496963
  506440
  506714
  508612
  509031
  509055
  509077
  510127
  511213
  512027
  512147
  512488
  516260
  520577
  522296
  522517
  522750
  524230
  535724
  537618
  544536
  551217
  552862
  553171
  553615
  556674
  557362
  559391
  561330
  565587
  568299
  568485
  570907
  577445
  596220
  596592
  598986
  600587
  608363
  618222
  618234
  621949
  623821
  626209
  632887
  639951
  650983
  651758
  653287
  665051
  677155
  690625
  725303
  728924
  730288
  741710
  744711
  746076
  752848
  753993
  761717
  762185
  766851
  773876
  777770
  789767
  794384
  797330
  803158
  807627
  812286
]
159.71 ms
(40.80%)
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
  383109
  396397
  397599
  410770
  413053
  418414
  418575
  422524
  427487
  430713
  431512
  432631
  437618
  437816
  440526
  440563
  441158
  443170
  445136
  449447
  449690
  453854
  455300
  455331
  456892
  456993
  457523
  458149
  461418
  462215
  463179
  467833
  473333
  475398
  475699
  476066
  476929
  477008
  481461
  481824
  483227
  484256
  490152
  490155
  491089
  492631
  492725
  494323
  495178
  496963
  506440
  506714
  508612
  509031
  509055
  509077
  510127
  511213
  512027
  512147
  512488
  516260
  520577
  522296
  522517
  522750
  524230
  535724
  537618
  544536
  551217
  552862
  553171
  553615
  556674
  557362
  559391
  561330
  565587
  568299
  568485
  570907
  577445
  596220
  596592
  598986
  600587
  608363
  618222
  618234
  621949
  623821
  626209
  632887
  639951
  650983
  651758
  653287
  665051
  677155
  690625
  725303
  728924
  730288
  741710
  744711
  746076
  752848
  753993
  761717
  762185
  766851
  773876
  777770
  789767
  794384
  797330
  803158
  807627
  812286
]
18.26 ms
(4.67%)
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
  437816
  441158
  511213
  544536
  552862
  651758
  690625
  553615
  577445
  746076
  475398
  397599
  440563
  462215
  741710
  812286
  752848
  476066
  455331
  467833
  445136
  484256
  556674
  600587
  807627
  432631
  461418
  490152
  453854
  475699
  481824
  520577
  512027
  621949
  596592
  598986
  773876
  618222
  794384
  803158
  440526
  494323
  553171
  427487
  557362
  418414
  508612
  431512
  410770
  492631
  516260
  535724
  665051
  608363
  725303
  458149
  477008
  443170
  510127
  491089
  522517
  422524
  473333
  483227
  495178
  565587
  551217
  677155
  777770
  789767
  753993
  437618
  456892
  463179
  481461
  449690
  476929
  522296
  506714
  492725
  383109
  430713
  456993
  496963
  509077
  524230
  561330
  559391
  570907
  568485
  653287
  650983
  623821
  626209
  639951
  596220
  618234
  761717
  762185
  744711
  413053
  455300
  396397
  418575
  457523
  449447
  522750
  512488
  537618
  568299
  632887
  766851
  728924
  730288
  797330
  506440
  509031
  509055
  490155
  512147
]
1.85 ms
(0.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "camera sex"
]
1.62 ms
(0.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "camera секс"
]
1.55 ms
(0.40%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.51 ms
(0.38%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "camera секс"
]

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.