Query Metrics
7
Database Queries
7
Different statements
242.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.99 ms (88.21%) |
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 191084 193761 279404 312447 382613 383224 386043 390925 390929 392754 398942 419521 420257 424411 424436 428890 439736 443292 443731 444000 448671 453074 454504 457487 460136 462695 465557 466170 466233 467256 470408 470424 472700 473740 474788 474873 475858 476278 478719 478935 480561 482296 482325 483260 484335 484750 486342 487751 490886 490930 490932 491440 492615 493098 493175 494516 495227 495228 495266 500458 502928 506830 507204 511518 513174 517953 519139 522413 523832 524025 526363 527183 528347 530341 532057 533425 533711 535022 538970 541599 544591 546447 546930 547737 551926 553174 555062 555280 555937 557122 560380 562567 562965 563098 563168 563204 563210 563450 563454 564817 578162 580940 589619 589681 590145 590321 590500 591128 591132 597089 603366 605485 606387 619396 619522 622833 663895 663988 666353 667864 ] |
||||||||||||||||||||||||||||||
|
18.19 ms (7.50%) |
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 470424 619522 619396 424436 443292 478719 444000 466233 390929 392754 476278 511518 390925 454504 483260 530341 532057 533711 495266 475858 551926 555937 553174 591128 603366 193761 448671 492615 526363 500458 563098 580940 589681 606387 462695 424411 494516 472700 474873 482296 478935 484335 493098 528347 524025 533425 460136 541599 562965 546930 564817 578162 546447 547737 560380 663895 663988 666353 667864 555062 557122 590321 590500 589619 590145 591132 428890 467256 398942 443731 466170 482325 453074 473740 191084 419521 470408 474788 517953 523832 538970 490886 495228 506830 490930 519139 486342 491440 493175 495227 527183 383224 312447 420257 457487 480561 507204 522413 465557 563168 555280 562567 544591 563204 563210 563454 597089 605485 386043 279404 382613 513174 490932 502928 487751 484750 622833 535022 563450 439736 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.11%) |
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 191084 193761 279404 312447 382613 383224 386043 390925 390929 392754 398942 419521 420257 424411 424436 428890 439736 443292 443731 444000 448671 453074 454504 457487 460136 462695 465557 466170 466233 467256 470408 470424 472700 473740 474788 474873 475858 476278 478719 478935 480561 482296 482325 483260 484335 484750 486342 487751 490886 490930 490932 491440 492615 493098 493175 494516 495227 495228 495266 500458 502928 506830 507204 511518 513174 517953 519139 522413 523832 524025 526363 527183 528347 530341 532057 533425 533711 535022 538970 541599 544591 546447 546930 547737 551926 553174 555062 555280 555937 557122 560380 562567 562965 563098 563168 563204 563210 563450 563454 564817 578162 580940 589619 589681 590145 590321 590500 591128 591132 597089 603366 605485 606387 619396 619522 622833 663895 663988 666353 667864 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature skirt"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature юбк"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature юбк"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.76%) |
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.