GET https://search.jues.net/search/embeds/7?q=old%20hidden

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.71 ms
(81.04%)
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
  388757
  395711
  395757
  399456
  407625
  409083
  418654
  419198
  428073
  433733
  443161
  447677
  452251
  458031
  462101
  464334
  464395
  466310
  467481
  470089
  481994
  482330
  483223
  483502
  484331
  484519
  484649
  489082
  491854
  492163
  492472
  493391
  494778
  498030
  498039
  504208
  504251
  504889
  512071
  514113
  514689
  514824
  520311
  523161
  525873
  526833
  528075
  538216
  540807
  544001
  545695
  546701
  547612
  548642
  550718
  554386
  554812
  555868
  559712
  560429
  563846
  565067
  566196
  566304
  569930
  572176
  573315
  575194
  577431
  577981
  578326
  580296
  584395
  586429
  586484
  587257
  590408
  590439
  594108
  594830
  597831
  599512
  604003
  607293
  610686
  611739
  611820
  612099
  614017
  614515
  615696
  617641
  618326
  620280
  623615
  623813
  624109
  624215
  626618
  628161
  637404
  638578
  650422
  650432
  651025
  663423
  669200
  673661
  682153
  684308
  698312
  698933
  702850
  716299
  727016
  727032
  748982
  790030
  799402
  807529
]
19.39 ms
(12.60%)
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
  560429
  554812
  566304
  573315
  548642
  698933
  682153
  698312
  590439
  623813
  702850
  462101
  466310
  492163
  498030
  489082
  663423
  594108
  727016
  504251
  458031
  716299
  790030
  799402
  388757
  514824
  673661
  545695
  586429
  610686
  620280
  447677
  514113
  494778
  504208
  498039
  399456
  418654
  544001
  669200
  684308
  650422
  650432
  651025
  626618
  748982
  443161
  520311
  554386
  575194
  578326
  580296
  547612
  559712
  611739
  597831
  594830
  604003
  612099
  611820
  617641
  492472
  514689
  484519
  407625
  428073
  584395
  577431
  577981
  628161
  638578
  807529
  727032
  409083
  482330
  467481
  504889
  546701
  565067
  555868
  624215
  624109
  590408
  599512
  483223
  484331
  491854
  563846
  572176
  481994
  395711
  493391
  464334
  566196
  433733
  470089
  483502
  538216
  512071
  569930
  550718
  614017
  419198
  464395
  525873
  523161
  395757
  452251
  526833
  607293
  587257
  540807
  484649
  586484
  637404
  623615
  614515
  615696
  618326
  528075
]
2.69 ms
(1.75%)
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
  388757
  395711
  395757
  399456
  407625
  409083
  418654
  419198
  428073
  433733
  443161
  447677
  452251
  458031
  462101
  464334
  464395
  466310
  467481
  470089
  481994
  482330
  483223
  483502
  484331
  484519
  484649
  489082
  491854
  492163
  492472
  493391
  494778
  498030
  498039
  504208
  504251
  504889
  512071
  514113
  514689
  514824
  520311
  523161
  525873
  526833
  528075
  538216
  540807
  544001
  545695
  546701
  547612
  548642
  550718
  554386
  554812
  555868
  559712
  560429
  563846
  565067
  566196
  566304
  569930
  572176
  573315
  575194
  577431
  577981
  578326
  580296
  584395
  586429
  586484
  587257
  590408
  590439
  594108
  594830
  597831
  599512
  604003
  607293
  610686
  611739
  611820
  612099
  614017
  614515
  615696
  617641
  618326
  620280
  623615
  623813
  624109
  624215
  626618
  628161
  637404
  638578
  650422
  650432
  651025
  663423
  669200
  673661
  682153
  684308
  698312
  698933
  702850
  716299
  727016
  727032
  748982
  790030
  799402
  807529
]
2.21 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "old hidden"
]
1.67 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "old скрыт"
]
1.56 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "old скрыт"
]

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.