Query Metrics
7
Database Queries
7
Different statements
404.94 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.75 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.02 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hidden hidden masturbation"
]
|
||||||||||||||||||||||||||||||
| 3 | 21.98 ms |
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 468767 489793 523781 472916 563034 611350 615838 475966 580933 605685 792845 766379 586429 610686 494778 493311 471093 525826 717533 753775 572917 534452 541470 651731 787972 799635 736023 559712 628273 783215 452861 550576 606601 595131 799642 752550 493242 488555 453002 518225 454672 690666 663423 576254 576759 628655 630370 780356 742285 765684 697513 434905 590702 589335 557947 428366 631538 744051 787281 755584 397478 495472 560679 556155 501903 547593 551795 553277 555432 544001 626618 810382 740694 756706 417826 423913 431427 462145 513215 682153 806435 475209 497831 528144 526718 482337 677238 595582 396589 459472 528139 502998 521153 539295 584019 594560 626082 461704 522763 565246 750611 433733 516296 555095 455217 554986 419198 424505 395757 538528 523253 603124 402985 618326 493163 ] |
||||||||||||||||||||||||||||||
| 4 | 2.99 ms |
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 395757 396589 397478 402985 417826 419198 423913 424505 428366 431427 433733 434905 452861 453002 454672 455217 459472 461704 462145 468767 471093 472916 475209 475966 482337 488555 489793 493163 493242 493311 494778 495472 497831 501903 502998 513215 516296 518225 521153 522763 523253 523781 525826 526718 528139 528144 534452 538528 539295 541470 544001 547593 550576 551795 553277 554986 555095 555432 556155 557947 559712 560679 563034 565246 572917 576254 576759 580933 584019 586429 589335 590702 594560 595131 595582 603124 605685 606601 610686 611350 615838 618326 626082 626618 628273 628655 630370 631538 651731 663423 677238 682153 690666 697513 717533 736023 740694 742285 744051 750611 752550 753775 755584 756706 765684 766379 780356 783215 787281 787972 792845 799635 799642 806435 810382 ] |
||||||||||||||||||||||||||||||
| 5 | 373.14 ms |
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 395757 396589 397478 402985 417826 419198 423913 424505 428366 431427 433733 434905 452861 453002 454672 455217 459472 461704 462145 468767 471093 472916 475209 475966 482337 488555 489793 493163 493242 493311 494778 495472 497831 501903 502998 513215 516296 518225 521153 522763 523253 523781 525826 526718 528139 528144 534452 538528 539295 541470 544001 547593 550576 551795 553277 554986 555095 555432 556155 557947 559712 560679 563034 565246 572917 576254 576759 580933 584019 586429 589335 590702 594560 595131 595582 603124 605685 606601 610686 611350 615838 618326 626082 626618 628273 628655 630370 631538 651731 663423 677238 682153 690666 697513 717533 736023 740694 742285 744051 750611 752550 753775 755584 756706 765684 766379 780356 783215 787281 787972 792845 799635 799642 806435 810382 ] |
||||||||||||||||||||||||||||||
| 6 | 1.73 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"скрыт скрыт мастурбац"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.33 ms |
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.