GET https://search.jues.net/search/embeds/10?q=big%20huge

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.96 ms
(83.24%)
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
  154694
  155232
  206144
  383290
  396088
  401733
  401816
  409060
  410980
  418078
  418558
  426470
  428874
  430508
  431794
  444731
  454814
  469833
  471185
  474876
  479818
  488017
  493838
  498525
  501703
  502832
  502894
  505024
  507181
  509643
  511302
  513022
  513893
  515418
  521267
  526985
  530050
  530053
  530752
  530796
  531544
  531724
  531888
  534354
  535372
  535543
  536557
  536559
  537319
  538076
  541376
  550324
  552881
  553430
  562797
  563927
  566164
  571194
  571826
  574375
  575899
  576533
  577718
  580866
  582595
  583199
  584425
  587445
  590512
  595524
  596133
  607638
  609877
  620755
  629281
  639819
  641807
  646435
  651290
  663263
  665210
  666658
  667498
  668834
  671008
  694894
  700990
  701875
  708517
  709764
  716246
  718701
  719203
  727920
  729538
  732161
  733398
  736289
  742360
  744774
  750881
  751722
  752627
  764160
  767454
  770237
  770964
  774333
  775903
  778384
  779464
  787130
  788154
  797637
  801147
  801475
  803458
  804192
  807373
  807991
]
14.52 ms
(9.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
  770237
  770964
  620755
  779464
  807373
  807991
  154694
  155232
  428874
  474876
  426470
  401816
  493838
  479818
  530050
  530796
  530053
  383290
  535372
  668834
  596133
  401733
  418558
  454814
  538076
  577718
  563927
  576533
  709764
  639819
  775903
  729538
  764160
  767454
  733398
  732161
  727920
  752627
  778384
  431794
  444731
  536557
  537319
  501703
  507181
  513022
  526985
  531544
  471185
  553430
  566164
  580866
  700990
  550324
  641807
  590512
  587445
  430508
  410980
  469833
  509643
  502894
  206144
  418078
  488017
  515418
  531888
  513893
  530752
  531724
  541376
  574375
  584425
  562797
  571194
  651290
  671008
  701875
  719203
  663263
  694894
  718701
  575899
  607638
  609877
  595524
  797637
  801147
  801475
  736289
  787130
  803458
  744774
  742360
  774333
  751722
  750881
  629281
  788154
  804192
  396088
  409060
  505024
  498525
  511302
  521267
  536559
  502832
  534354
  535543
  571826
  583199
  582595
  552881
  666658
  716246
  646435
  665210
  667498
  708517
]
3.15 ms
(2.10%)
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
  154694
  155232
  206144
  383290
  396088
  401733
  401816
  409060
  410980
  418078
  418558
  426470
  428874
  430508
  431794
  444731
  454814
  469833
  471185
  474876
  479818
  488017
  493838
  498525
  501703
  502832
  502894
  505024
  507181
  509643
  511302
  513022
  513893
  515418
  521267
  526985
  530050
  530053
  530752
  530796
  531544
  531724
  531888
  534354
  535372
  535543
  536557
  536559
  537319
  538076
  541376
  550324
  552881
  553430
  562797
  563927
  566164
  571194
  571826
  574375
  575899
  576533
  577718
  580866
  582595
  583199
  584425
  587445
  590512
  595524
  596133
  607638
  609877
  620755
  629281
  639819
  641807
  646435
  651290
  663263
  665210
  666658
  667498
  668834
  671008
  694894
  700990
  701875
  708517
  709764
  716246
  718701
  719203
  727920
  729538
  732161
  733398
  736289
  742360
  744774
  750881
  751722
  752627
  764160
  767454
  770237
  770964
  774333
  775903
  778384
  779464
  787130
  788154
  797637
  801147
  801475
  803458
  804192
  807373
  807991
]
2.30 ms
(1.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big huge"
]
1.80 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие огромные"
]
1.69 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(1.12%)
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.