GET https://search.jues.net/search/embeds/3?q=big%20job

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.61 ms
(84.94%)
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
  34146
  361286
  396349
  399759
  405070
  408998
  417738
  418922
  420516
  422879
  428664
  429069
  429424
  431546
  437573
  437579
  438844
  440927
  441696
  446244
  447895
  448518
  451549
  455025
  456584
  457176
  460608
  462394
  465194
  468647
  471961
  472671
  472833
  474591
  478573
  481684
  482101
  484797
  485082
  485165
  486789
  491732
  491733
  491922
  493319
  495082
  496302
  496854
  497369
  497798
  498657
  509977
  510686
  510690
  515663
  516636
  516666
  519671
  519701
  520427
  521154
  522784
  522997
  524810
  525821
  526789
  526828
  528906
  533499
  535342
  535919
  536683
  536759
  536774
  539029
  542074
  546580
  549746
  553314
  555050
  565347
  566057
  566064
  566228
  566933
  567321
  576445
  579527
  581269
  588631
  589756
  591092
  592413
  593476
  595037
  596793
  603187
  608639
  611700
  625169
  641140
  642934
  650780
  681413
  685578
  687980
  726997
  727041
  731442
  733480
  740804
  759987
  760837
  762158
  794362
  810986
  812061
  817319
  818998
  820338
]
14.98 ms
(9.38%)
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
  478573
  546580
  625169
  524810
  820338
  685578
  650780
  733480
  762158
  441696
  817319
  818998
  565347
  608639
  794362
  451549
  485165
  448518
  465194
  472671
  446244
  536683
  760837
  812061
  440927
  525821
  491733
  493319
  34146
  474591
  496302
  533499
  468647
  455025
  497369
  521154
  731442
  361286
  536759
  576445
  566064
  555050
  603187
  641140
  589756
  642934
  740804
  611700
  495082
  396349
  457176
  456584
  471961
  522997
  549746
  566228
  566057
  759987
  417738
  437579
  462394
  405070
  497798
  535919
  486789
  687980
  810986
  431546
  509977
  422879
  526789
  539029
  485082
  593476
  428664
  437573
  460608
  491732
  498657
  510686
  510690
  447895
  481684
  408998
  536774
  519701
  726997
  727041
  520427
  399759
  516666
  566933
  542074
  579527
  591092
  592413
  516636
  553314
  596793
  496854
  420516
  515663
  522784
  581269
  567321
  588631
  429069
  438844
  528906
  491922
  472833
  681413
  595037
  429424
  482101
  526828
  418922
  535342
  484797
  519671
]
2.92 ms
(1.83%)
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
  34146
  361286
  396349
  399759
  405070
  408998
  417738
  418922
  420516
  422879
  428664
  429069
  429424
  431546
  437573
  437579
  438844
  440927
  441696
  446244
  447895
  448518
  451549
  455025
  456584
  457176
  460608
  462394
  465194
  468647
  471961
  472671
  472833
  474591
  478573
  481684
  482101
  484797
  485082
  485165
  486789
  491732
  491733
  491922
  493319
  495082
  496302
  496854
  497369
  497798
  498657
  509977
  510686
  510690
  515663
  516636
  516666
  519671
  519701
  520427
  521154
  522784
  522997
  524810
  525821
  526789
  526828
  528906
  533499
  535342
  535919
  536683
  536759
  536774
  539029
  542074
  546580
  549746
  553314
  555050
  565347
  566057
  566064
  566228
  566933
  567321
  576445
  579527
  581269
  588631
  589756
  591092
  592413
  593476
  595037
  596793
  603187
  608639
  611700
  625169
  641140
  642934
  650780
  681413
  685578
  687980
  726997
  727041
  731442
  733480
  740804
  759987
  760837
  762158
  794362
  810986
  812061
  817319
  818998
  820338
]
1.68 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big job"
]
1.68 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие job"
]
1.43 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие job"
]
1.37 ms
(0.86%)
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.