Query Metrics
7
Database Queries
7
Different statements
189.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.72 ms (84.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 205520 360015 395547 395609 395812 398559 399209 400965 401305 401932 401936 415112 415223 418418 420331 420439 422511 422565 422652 422657 422670 422709 422863 422901 422936 422985 422996 423006 423007 428631 431333 433185 437084 439658 439844 445897 445933 446875 448325 451554 455841 459360 461723 463811 466161 466987 473955 476962 484730 486354 489661 491232 491644 494692 496818 509940 510505 511809 518472 520729 524089 530494 530670 531090 532831 534280 536218 543013 548548 548574 551081 561982 562511 565255 565259 579358 595853 596501 596616 597266 604417 604507 613287 615718 619409 620851 622391 622397 628090 628365 628368 628407 628420 632046 633782 637078 637134 646229 647850 647877 647969 659392 659409 671676 672805 699610 714436 714480 714497 722689 723927 733884 733886 741109 760958 777551 788198 791181 800421 820385 ] |
||||||||||||||||||||||||||||||
|
19.11 ms (10.08%) |
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 659392 672805 723927 360015 422996 422652 551081 647877 699610 659409 646229 632046 415112 510505 620851 791181 820385 800421 777551 788198 613287 415223 466987 484730 548548 548574 395812 399209 420331 466161 431333 494692 532831 486354 491644 423006 437084 445933 455841 451554 562511 543013 561982 722689 714480 622391 619409 596501 628407 741109 604417 622397 401932 439658 476962 401936 418418 473955 395609 398559 448325 422985 463811 491232 520729 205520 395547 400965 401305 422709 422901 422936 428631 422670 422511 422565 422657 445897 459360 511809 524089 534280 530494 531090 536218 579358 565255 647969 647850 671676 714497 604507 637134 595853 597266 628365 628090 628368 637078 628420 733884 733886 760958 633782 714436 439844 446875 420439 422863 489661 496818 518472 509940 433185 530670 565259 615718 596616 461723 423007 ] |
||||||||||||||||||||||||||||||
|
3.42 ms (1.80%) |
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 205520 360015 395547 395609 395812 398559 399209 400965 401305 401932 401936 415112 415223 418418 420331 420439 422511 422565 422652 422657 422670 422709 422863 422901 422936 422985 422996 423006 423007 428631 431333 433185 437084 439658 439844 445897 445933 446875 448325 451554 455841 459360 461723 463811 466161 466987 473955 476962 484730 486354 489661 491232 491644 494692 496818 509940 510505 511809 518472 520729 524089 530494 530670 531090 532831 534280 536218 543013 548548 548574 551081 561982 562511 565255 565259 579358 595853 596501 596616 597266 604417 604507 613287 615718 619409 620851 622391 622397 628090 628365 628368 628407 628420 632046 633782 637078 637134 646229 647850 647877 647969 659392 659409 671676 672805 699610 714436 714480 714497 722689 723927 733884 733886 741109 760958 777551 788198 791181 800421 820385 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал young сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал young сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal young tits"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.92%) |
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.