GET https://search.jues.net/search/embeds/9?q=teen%20tights

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.29 ms
(85.62%)
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
  7390
  73622
  391190
  398132
  410255
  410285
  414197
  419655
  422546
  422593
  422671
  422929
  423025
  423592
  425339
  425356
  427591
  429086
  430469
  432376
  432448
  432452
  432455
  432928
  433058
  433218
  433322
  433390
  433461
  433571
  433599
  433706
  433715
  445289
  446086
  447147
  447611
  455126
  456466
  456546
  456591
  461937
  463101
  466351
  468949
  472746
  477775
  481105
  482925
  483903
  485456
  490278
  491250
  491704
  491961
  498582
  503576
  508276
  521022
  521559
  524403
  525397
  526905
  527515
  528782
  529060
  529081
  530146
  533783
  534063
  541274
  552346
  552494
  561313
  571229
  572359
  586005
  598020
  598484
  598836
  620851
  623203
  643042
  647996
  651666
  656499
  656935
  665920
  695125
  713885
  721538
  722482
  723287
  730011
  733860
  733877
  744620
  745126
  745136
  748354
  748951
  752633
  757105
  758788
  760007
  766605
  766607
  766831
  766880
  770213
  770263
  777051
  788553
  788776
  788800
  808728
  813573
  815013
  819530
]
15.90 ms
(8.71%)
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
  620851
  491250
  7390
  391190
  398132
  427591
  432928
  422593
  433706
  422929
  819530
  446086
  463101
  477775
  483903
  521022
  525397
  529081
  529060
  521559
  526905
  527515
  530146
  461937
  541274
  552494
  572359
  561313
  552346
  571229
  656499
  665920
  647996
  656935
  713885
  695125
  721538
  723287
  616047
  586005
  598020
  643042
  598484
  598836
  777051
  788553
  757105
  766831
  770263
  788776
  808728
  733860
  733877
  748951
  758788
  766605
  770213
  744620
  745126
  730011
  745136
  766880
  748354
  752633
  760007
  766607
  722482
  788800
  419655
  432455
  466351
  472746
  432448
  433715
  73622
  414197
  432376
  433322
  433390
  433461
  433571
  456591
  481105
  410255
  410285
  432452
  433218
  433599
  447611
  456466
  447147
  482925
  490278
  491704
  498582
  508276
  534063
  485456
  491961
  503576
  524403
  425356
  651666
  623203
  422671
  430469
  425339
  429086
  422546
  423592
  423025
  433058
  445289
  813573
  815013
  456546
  455126
  468949
  528782
  533783
]
2.97 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
  7390
  73622
  391190
  398132
  410255
  410285
  414197
  419655
  422546
  422593
  422671
  422929
  423025
  423592
  425339
  425356
  427591
  429086
  430469
  432376
  432448
  432452
  432455
  432928
  433058
  433218
  433322
  433390
  433461
  433571
  433599
  433706
  433715
  445289
  446086
  447147
  447611
  455126
  456466
  456546
  456591
  461937
  463101
  466351
  468949
  472746
  477775
  481105
  482925
  483903
  485456
  490278
  491250
  491704
  491961
  498582
  503576
  508276
  521022
  521559
  524403
  525397
  526905
  527515
  528782
  529060
  529081
  530146
  533783
  534063
  541274
  552346
  552494
  561313
  571229
  572359
  586005
  598020
  598484
  598836
  620851
  623203
  643042
  647996
  651666
  656499
  656935
  665920
  695125
  713885
  721538
  722482
  723287
  730011
  733860
  733877
  744620
  745126
  745136
  748354
  748951
  752633
  757105
  758788
  760007
  766605
  766607
  766831
  766880
  770213
  770263
  777051
  788553
  788776
  788800
  808728
  813573
  815013
  819530
]
1.99 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen колготк"
]
1.99 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen tights"
]
1.79 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen колготк"
]
1.63 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.