Query Metrics
8
Database Queries
8
Different statements
302.80 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.81 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.92 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс видео"
]
|
||||||||||||||||||||||||||||||
| 3 | 1.91 ms |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01Æý\x18æàpäÉ#Z\x02·ý¼╩"
]
|
||||||||||||||||||||||||||||||
| 4 | 18.39 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 809934 123554 422227 12731 396951 412189 487746 807191 824207 707434 631185 385799 206202 223551 310715 334950 382129 390437 396015 398756 399162 406621 417837 413597 406992 408241 585013 470504 447962 451798 464165 451015 464949 531164 538449 514718 504252 478618 576685 663444 650843 669410 680691 684914 704044 670820 694641 710832 562888 584710 610007 613872 628416 625400 644259 597852 628707 807518 810685 810694 792627 724528 758972 633051 636545 699621 797849 382438 386460 404240 423567 95864 96843 383491 395740 396234 460684 191356 443685 473981 404615 456445 491272 490227 496117 521993 487582 386408 123955 21594 29429 396936 817518 543232 790961 758603 770820 798797 411943 573394 433212 487383 503831 544528 558786 672469 545586 610786 600843 461503 471584 382853 396542 396566 823205 820032 827881 533523 532268 555152 ] |
||||||||||||||||||||||||||||||
| 5 | 3.10 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 12731 21594 29429 95864 96843 123554 123955 191356 206202 223551 310715 334950 382129 382438 382853 383491 385799 386408 386460 390437 395740 396015 396234 396542 396566 396936 396951 398756 399162 404240 404615 406621 406992 408241 411943 412189 413597 417837 422227 423567 433212 443685 447962 451015 451798 456445 460684 461503 464165 464949 470504 471584 473981 478618 487383 487582 487746 490227 491272 496117 503831 504252 514718 521993 531164 532268 533523 538449 543232 544528 545586 555152 558786 562888 573394 576685 584710 585013 597852 600843 610007 610786 613872 625400 628416 628707 631185 633051 636545 644259 650843 663444 669410 670820 672469 680691 684914 694641 699621 704044 707434 710832 724528 758603 758972 770820 790961 792627 797849 798797 807191 807518 809934 810685 810694 817518 820032 823205 827881 ] |
||||||||||||||||||||||||||||||
| 6 | 270.62 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 12731 21594 29429 95864 96843 123554 123955 191356 206202 223551 310715 334950 382129 382438 382853 383491 385799 386408 386460 390437 395740 396015 396234 396542 396566 396936 396951 398756 399162 404240 404615 406621 406992 408241 411943 412189 413597 417837 422227 423567 433212 443685 447962 451015 451798 456445 460684 461503 464165 464949 470504 471584 473981 478618 487383 487582 487746 490227 491272 496117 503831 504252 514718 521993 531164 532268 533523 538449 543232 544528 545586 555152 558786 562888 573394 576685 584710 585013 597852 600843 610007 610786 613872 625400 628416 628707 631185 633051 636545 644259 650843 663444 669410 670820 672469 680691 684914 694641 699621 704044 707434 710832 724528 758603 758972 770820 790961 792627 797849 798797 807191 807518 809934 810685 810694 817518 820032 823205 827881 ] |
||||||||||||||||||||||||||||||
| 7 | 2.34 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс виде"
]
|
||||||||||||||||||||||||||||||
| 8 | 2.70 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.