Query Metrics
7
Database Queries
7
Different statements
162.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.23 ms (84.60%) |
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 67464 124661 180923 191728 308886 366448 382024 382697 384807 385899 386285 386350 388434 390854 393737 395549 395931 396165 397400 405315 407418 419055 419534 421283 429486 433835 434181 434803 435052 443978 444734 450069 451279 451666 452393 456029 456193 458667 463212 464300 465661 465822 465882 466039 466043 467183 468975 471956 474484 474566 478050 479276 485522 493100 493408 493914 495583 499912 500076 501179 501643 507170 515575 515610 515728 518139 521170 522591 522666 523487 527852 529861 536603 550505 563220 567433 567755 568699 570765 573481 583729 588335 588347 588359 590513 595774 600888 601297 601469 606682 623608 630754 643127 644636 650785 661908 671647 689715 705530 708840 712701 717748 747386 747527 752920 759956 759987 763682 791787 799965 815123 815128 815895 815923 817006 817868 817934 818424 818432 818726 ] |
||||||||||||||||||||||||||||||
|
15.13 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 522666 817934 818424 536603 590513 791787 595774 382024 671647 583729 522591 527852 550505 435052 434803 451666 456193 386285 515575 759956 493408 456029 421283 468975 471956 563220 493914 382697 501643 385899 500076 464300 452393 466039 419534 485522 191728 419055 818432 799965 747386 501179 630754 661908 451279 405315 567755 495583 429486 529861 568699 443978 450069 478050 465882 466043 606682 570765 433835 308886 515728 366448 643127 600888 712701 717748 573481 395931 817868 499912 601297 752920 396165 479276 386350 474484 644636 815923 601469 747527 763682 759987 124661 388434 818726 650785 588347 523487 407418 515610 817006 705530 588359 434181 444734 395549 521170 67464 474566 815128 567433 815895 815123 180923 384807 465661 518139 467183 493100 507170 465822 588335 458667 463212 393737 397400 689715 708840 390854 623608 ] |
||||||||||||||||||||||||||||||
|
3.29 ms (2.03%) |
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 67464 124661 180923 191728 308886 366448 382024 382697 384807 385899 386285 386350 388434 390854 393737 395549 395931 396165 397400 405315 407418 419055 419534 421283 429486 433835 434181 434803 435052 443978 444734 450069 451279 451666 452393 456029 456193 458667 463212 464300 465661 465822 465882 466039 466043 467183 468975 471956 474484 474566 478050 479276 485522 493100 493408 493914 495583 499912 500076 501179 501643 507170 515575 515610 515728 518139 521170 522591 522666 523487 527852 529861 536603 550505 563220 567433 567755 568699 570765 573481 583729 588335 588347 588359 590513 595774 600888 601297 601469 606682 623608 630754 643127 644636 650785 661908 671647 689715 705530 708840 712701 717748 747386 747527 752920 759956 759987 763682 791787 799965 815123 815128 815895 815923 817006 817868 817934 818424 818432 818726 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob secretary"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс секретарш"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.