Query Metrics
7
Database Queries
7
Different statements
174.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.77 ms (85.44%) |
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 16971 381928 391908 396917 413592 414184 414723 417058 418837 420139 421050 421130 423940 424364 424523 424648 425131 426710 428185 429383 432771 434275 434456 436718 442358 443648 443910 443926 444692 445652 447803 448121 448215 454294 454527 455919 456427 456437 458694 459395 459565 462209 467700 469924 473787 473969 474019 474631 476151 477554 478562 478608 479049 482499 482510 483037 485155 490261 490304 494036 495890 508720 509810 511875 513859 514949 516307 516319 516351 516375 516635 517125 517640 518547 522227 524527 525702 526223 526277 527900 534147 543817 544528 550820 566112 566422 567581 567951 583502 586024 586435 587970 589200 590560 590857 593269 593868 597873 598918 599197 602506 602928 603269 604061 610278 610905 637041 639044 645749 650487 663294 667985 670239 679821 720836 720883 727041 728397 731226 738440 ] |
||||||||||||||||||||||||||||||
|
16.24 ms (9.33%) |
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 516319 517640 527900 663294 639044 454294 516635 483037 391908 645749 583502 567951 516375 599197 443926 432771 444692 420139 456427 448121 478608 550820 604061 458694 424523 476151 514949 602928 16971 522227 381928 414723 567581 516351 566112 396917 428185 495890 467700 679821 598918 637041 443648 474019 417058 526277 477554 429383 442358 482499 459565 490304 516307 543817 566422 670239 720836 728397 423940 426710 478562 469924 508720 525702 610905 534147 590857 589200 485155 509810 425131 610278 413592 474631 526223 447803 462209 511875 436718 482510 459395 518547 490261 650487 586435 603269 597873 727041 738440 720883 414184 473969 421050 443910 517125 424364 434456 421130 448215 590560 731226 479049 424648 456437 473787 445652 587970 593269 494036 593868 418837 455919 513859 544528 667985 586024 602506 434275 454527 524527 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.40%) |
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 16971 381928 391908 396917 413592 414184 414723 417058 418837 420139 421050 421130 423940 424364 424523 424648 425131 426710 428185 429383 432771 434275 434456 436718 442358 443648 443910 443926 444692 445652 447803 448121 448215 454294 454527 455919 456427 456437 458694 459395 459565 462209 467700 469924 473787 473969 474019 474631 476151 477554 478562 478608 479049 482499 482510 483037 485155 490261 490304 494036 495890 508720 509810 511875 513859 514949 516307 516319 516351 516375 516635 517125 517640 518547 522227 524527 525702 526223 526277 527900 534147 543817 544528 550820 566112 566422 567581 567951 583502 586024 586435 587970 589200 590560 590857 593269 593868 597873 598918 599197 602506 602928 603269 604061 610278 610905 637041 639044 645749 650487 663294 667985 670239 679821 720836 720883 727041 728397 731226 738440 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"swinger amateur anal"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"свингер любительск анал"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.