Query Metrics
7
Database Queries
7
Different statements
381.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.14 ms (54.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian young"
]
|
||||||||||||||||||||||||||||||
|
149.23 ms (39.16%) |
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 53992 385913 386211 391002 401120 401344 402266 416191 418332 420613 422511 422513 422514 422543 422550 422572 422591 422592 422610 422625 422630 422654 422657 422661 422705 422709 422711 422834 422847 422862 422901 422908 422923 422934 422958 422959 422969 422985 422993 422997 423006 423007 423009 423021 423022 423023 423025 423243 423263 423266 423270 423271 423280 423283 423412 424946 429565 433610 435727 443225 446258 446266 452434 453331 456627 456633 456634 456642 477216 491354 501865 517997 525605 529182 534776 537568 537732 539519 547642 550523 550642 550644 551017 551066 551947 554426 556397 559909 562872 564066 565996 566009 581393 583397 585398 594960 595765 595945 595952 600559 602044 619451 623499 630192 691221 714119 720829 737151 741109 744704 745764 747984 748684 748686 759782 792722 805279 808754 808756 821625 ] |
||||||||||||||||||||||||||||||
|
15.35 ms (4.03%) |
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 422630 422709 422901 420613 422511 422657 446266 456633 556397 422705 456627 491354 418332 423007 423021 423270 422625 422847 422514 422572 429565 423025 452434 537732 583397 554426 562872 720829 564066 585398 623499 595952 595945 805279 748686 808756 423009 423263 422862 423271 402266 422543 422610 477216 422923 501865 581393 550642 737151 792722 550523 565996 537568 566009 745764 391002 550644 422958 422592 619451 422513 435727 385913 401120 422969 423243 443225 422934 525605 517997 551017 551066 551947 559909 630192 595765 600559 808754 747984 759782 602044 53992 422959 401344 416191 422993 423006 423023 422661 422997 422550 422654 422834 424946 422591 422908 423283 456634 453331 534776 529182 691221 714119 594960 741109 748684 744704 423022 446258 386211 423412 433610 456642 423280 422711 422985 423266 821625 539519 547642 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (0.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 53992 385913 386211 391002 401120 401344 402266 416191 418332 420613 422511 422513 422514 422543 422550 422572 422591 422592 422610 422625 422630 422654 422657 422661 422705 422709 422711 422834 422847 422862 422901 422908 422923 422934 422958 422959 422969 422985 422993 422997 423006 423007 423009 423021 423022 423023 423025 423243 423263 423266 423270 423271 423280 423283 423412 424946 429565 433610 435727 443225 446258 446266 452434 453331 456627 456633 456634 456642 477216 491354 501865 517997 525605 529182 534776 537568 537732 539519 547642 550523 550642 550644 551017 551066 551947 554426 556397 559909 562872 564066 565996 566009 581393 583397 585398 594960 595765 595945 595952 600559 602044 619451 623499 630192 691221 714119 720829 737151 741109 744704 745764 747984 748684 748686 759782 792722 805279 808754 808756 821625 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк young"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"азиатк young"
]
|
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.