Query Metrics
7
Database Queries
7
Different statements
156.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.89 ms (82.92%) |
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 188254 388519 389571 393508 397992 398353 422347 442695 443518 450146 454293 459896 460243 464460 464561 465214 466277 466801 467691 468374 468798 468886 470298 470639 470925 471449 472867 473775 478002 479024 479078 482325 482391 482511 484335 490917 490921 491120 492458 493224 493401 493478 494195 495852 496186 498481 498730 500230 500394 502712 505251 509060 509317 511535 511594 517863 519339 526703 526827 527158 534676 534697 540119 541107 541369 544489 545694 549846 551756 555126 557145 557732 558020 581183 620220 626378 645048 663505 664825 665215 665240 665306 665487 665850 669783 677971 678777 681216 713384 715116 718570 720533 725345 725504 726396 726419 726646 730076 731090 736422 740158 742235 746632 748467 758414 759108 764279 765640 777417 777654 790976 796123 801055 801319 802899 808210 811494 816507 819044 824062 ] |
||||||||||||||||||||||||||||||
|
15.27 ms (9.75%) |
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 665306 746632 824062 677971 801055 725345 726646 819044 557145 811494 720533 551756 534697 777654 718570 764279 188254 758414 726396 736422 494195 541369 759108 540119 388519 713384 731090 478002 398353 493478 541107 397992 460243 730076 790976 665240 777417 468798 669783 495852 748467 493401 664825 665215 470639 681216 527158 393508 389571 725504 663505 450146 581183 665487 470925 511535 645048 473775 801319 511594 500230 558020 465214 468374 765640 500394 665850 442695 678777 545694 526703 620220 464460 742235 726419 808210 549846 557732 626378 443518 466801 468886 490917 498481 509060 472867 479024 471449 509317 479078 496186 482511 467691 796123 505251 491120 519339 802899 816507 459896 493224 490921 482391 482325 517863 422347 484335 715116 534676 544489 454293 502712 464561 470298 526827 492458 555126 498730 466277 740158 ] |
||||||||||||||||||||||||||||||
|
4.05 ms (2.58%) |
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 188254 388519 389571 393508 397992 398353 422347 442695 443518 450146 454293 459896 460243 464460 464561 465214 466277 466801 467691 468374 468798 468886 470298 470639 470925 471449 472867 473775 478002 479024 479078 482325 482391 482511 484335 490917 490921 491120 492458 493224 493401 493478 494195 495852 496186 498481 498730 500230 500394 502712 505251 509060 509317 511535 511594 517863 519339 526703 526827 527158 534676 534697 540119 541107 541369 544489 545694 549846 551756 555126 557145 557732 558020 581183 620220 626378 645048 663505 664825 665215 665240 665306 665487 665850 669783 677971 678777 681216 713384 715116 718570 720533 725345 725504 726396 726419 726646 730076 731090 736422 740158 742235 746632 748467 758414 759108 764279 765640 777417 777654 790976 796123 801055 801319 802899 808210 811494 816507 819044 824062 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"большой член и зрелая%…"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большой большие член зрелая женщин"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большой большие член зрелая женщин"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.06%) |
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.