Query Metrics
7
Database Queries
7
Different statements
150.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.37 ms (82.22%) |
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 23524 208999 291689 361286 382018 382812 383734 384845 386023 386050 386794 388212 388522 390889 390925 394754 395237 396278 398354 398614 401859 403904 410606 415452 415917 417265 418059 418304 418305 419055 420025 421038 422503 422621 422630 422705 422958 423225 423242 424830 426248 426468 429764 432136 433512 443301 447908 448353 451961 454857 457112 457264 457498 458094 458382 459262 468753 469536 475448 475812 480801 486837 497459 510423 523560 527094 529833 533691 542944 551888 551950 552827 554340 556403 556412 559855 559865 559875 565205 565470 572727 583068 583298 590280 590949 606699 608026 613857 614731 618697 619432 619433 623516 623822 630619 632605 632682 635484 637115 642841 644363 645559 650825 668950 694194 694468 712169 715125 720872 720889 729065 742478 748136 759548 771936 785111 810016 815435 817300 820741 ] |
||||||||||||||||||||||||||||||
|
15.78 ms (10.52%) |
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 742478 451961 529833 458382 497459 443301 422958 429764 480801 454857 291689 635484 386050 208999 619432 748136 382812 422630 590280 395237 361286 422503 720872 637115 632605 771936 426468 527094 426248 433512 556412 632682 468753 398354 403904 418059 421038 552827 432136 383734 565470 419055 533691 559875 551888 554340 645559 668950 694468 630619 608026 618697 623516 785111 810016 388522 396278 422621 475812 613857 542944 469536 815435 817300 551950 458094 457498 650825 424830 556403 583068 642841 420025 510423 565205 694194 720889 614731 606699 644363 590949 386023 390925 401859 712169 729065 715125 382018 418304 417265 447908 475448 448353 457112 418305 423225 486837 523560 572727 459262 623822 415917 384845 386794 388212 23524 415452 422705 583298 457264 398614 820741 390889 759548 423242 559865 559855 619433 394754 410606 ] |
||||||||||||||||||||||||||||||
|
3.38 ms (2.25%) |
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 23524 208999 291689 361286 382018 382812 383734 384845 386023 386050 386794 388212 388522 390889 390925 394754 395237 396278 398354 398614 401859 403904 410606 415452 415917 417265 418059 418304 418305 419055 420025 421038 422503 422621 422630 422705 422958 423225 423242 424830 426248 426468 429764 432136 433512 443301 447908 448353 451961 454857 457112 457264 457498 458094 458382 459262 468753 469536 475448 475812 480801 486837 497459 510423 523560 527094 529833 533691 542944 551888 551950 552827 554340 556403 556412 559855 559865 559875 565205 565470 572727 583068 583298 590280 590949 606699 608026 613857 614731 618697 619432 619433 623516 623822 630619 632605 632682 635484 637115 642841 644363 645559 650825 668950 694194 694468 712169 715125 720872 720889 729065 742478 748136 759548 771936 785111 810016 815435 817300 820741 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian blow job"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.08%) |
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.