Query Metrics
7
Database Queries
7
Different statements
194.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.08 ms (86.08%) |
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 96484 96690 385324 387599 395845 399904 413373 426710 426712 432786 432970 434596 443660 443926 445828 448521 448558 452474 452805 453622 453698 456427 459649 459703 462150 462526 463059 464193 467561 467572 470150 470535 471125 474289 474872 477554 477943 479069 482136 482510 482632 486476 486776 486855 488825 494567 494815 495050 495149 497837 499148 504136 505619 506059 506415 506478 506989 507310 509728 509982 509998 512505 512512 519261 519880 520270 525577 526125 527814 528502 532940 539286 544508 546668 553926 558626 561748 563411 565283 566439 569211 571146 579505 580194 581174 583691 587416 590856 593886 602966 603649 603682 603686 610822 619935 624429 625385 627703 644915 649614 650823 653956 670717 696920 705520 719808 720740 724264 729627 733573 755170 756405 770672 775958 775976 778359 790034 795396 809520 809533 ] |
||||||||||||||||||||||||||||||
|
17.66 ms (9.10%) |
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 479069 506059 452805 724264 399904 546668 603649 775976 477943 610822 602966 650823 443926 482136 809520 506989 558626 509728 553926 426712 482632 96484 507310 566439 587416 580194 696920 445828 432970 387599 462526 471125 467572 474289 443660 790034 563411 519261 477554 474872 532940 795396 434596 519880 525577 497837 809533 619935 467561 486776 733573 627703 452474 506478 486476 499148 526125 571146 527814 778359 459703 625385 448521 395845 775958 644915 512505 590856 528502 432786 539286 494815 720740 459649 413373 509998 495050 649614 482510 520270 96690 583691 670717 719808 603686 755170 770672 504136 488825 456427 756405 470150 624429 565283 593886 453698 494567 462150 544508 579505 653956 569211 453622 464193 512512 705520 486855 506415 505619 509982 561748 581174 729627 495149 426710 463059 603682 385324 448558 470535 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (1.48%) |
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 96484 96690 385324 387599 395845 399904 413373 426710 426712 432786 432970 434596 443660 443926 445828 448521 448558 452474 452805 453622 453698 456427 459649 459703 462150 462526 463059 464193 467561 467572 470150 470535 471125 474289 474872 477554 477943 479069 482136 482510 482632 486476 486776 486855 488825 494567 494815 495050 495149 497837 499148 504136 505619 506059 506415 506478 506989 507310 509728 509982 509998 512505 512512 519261 519880 520270 525577 526125 527814 528502 532940 539286 544508 546668 553926 558626 561748 563411 565283 566439 569211 571146 579505 580194 581174 583691 587416 590856 593886 602966 603649 603682 603686 610822 619935 624429 625385 627703 644915 649614 650823 653956 670717 696920 705520 719808 720740 724264 729627 733573 755170 756405 770672 775958 775976 778359 790034 795396 809520 809533 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade double blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск double минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.72%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск double минет оральн секс"
]
|
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.