Query Metrics
7
Database Queries
7
Different statements
160.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.99 ms (77.77%) |
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 334847 382184 382918 383063 385376 395142 395556 395924 397217 397999 398243 400134 401978 403003 403907 407682 407709 407710 417990 421236 421875 422243 422255 428539 428895 429528 433977 437361 439549 439695 439698 442469 443158 443182 443184 444044 444468 445709 446622 446968 448459 450147 450995 455957 456605 457200 458018 458378 458928 460156 460195 460658 460677 463624 464423 464446 464556 466709 472299 474498 477110 477987 486896 495225 496292 502812 502813 505973 506136 511016 513707 513784 517282 518341 518847 520916 521473 521490 523031 523829 524262 524284 524289 524486 524652 524655 526728 532004 532056 533425 537126 538002 550223 550643 554897 557551 562952 563423 563432 566928 579209 608415 610587 619717 622665 663772 665492 689002 699604 723945 723955 724045 724456 727891 743431 744184 744563 753148 769536 ] |
||||||||||||||||||||||||||||||
|
25.05 ms (15.58%) |
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 505973 382918 395142 395924 395556 398243 397999 401978 407682 428539 429528 407710 437361 443182 445709 450147 457200 446622 460156 464446 464556 486896 450995 458018 464423 466709 513784 524289 532004 524652 506136 532056 460195 554897 579209 550223 550643 716936 663772 689002 562952 563423 608415 622665 723955 724045 727891 744184 724456 743431 744563 769536 723945 753148 699604 448459 477987 400134 334847 474498 477110 521473 523031 496292 518341 526728 521490 524655 513707 460658 472299 421236 458378 517282 502812 557551 665492 610587 524486 428895 439695 524284 523829 385376 444468 443158 446968 455957 456605 458928 537126 511016 518847 524262 533425 460677 563432 566928 619717 422243 463624 421875 433977 439698 444044 443184 538002 502813 495225 520916 383063 382184 397217 403003 403907 407709 422255 417990 439549 442469 ] |
||||||||||||||||||||||||||||||
|
3.53 ms (2.19%) |
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 334847 382184 382918 383063 385376 395142 395556 395924 397217 397999 398243 400134 401978 403003 403907 407682 407709 407710 417990 421236 421875 422243 422255 428539 428895 429528 433977 437361 439549 439695 439698 442469 443158 443182 443184 444044 444468 445709 446622 446968 448459 450147 450995 455957 456605 457200 458018 458378 458928 460156 460195 460658 460677 463624 464423 464446 464556 466709 472299 474498 477110 477987 486896 495225 496292 502812 502813 505973 506136 511016 513707 513784 517282 518341 518847 520916 521473 521490 523031 523829 524262 524284 524289 524486 524652 524655 526728 532004 532056 533425 537126 538002 550223 550643 554897 557551 562952 563423 563432 566928 579209 608415 610587 619717 622665 663772 665492 689002 699604 723945 723955 724045 724456 727891 743431 744184 744563 753148 769536 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public mom son"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на mom улиц son"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на mom улиц son"
]
|
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.