Query Metrics
7
Database Queries
7
Different statements
191.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.55 ms (86.65%) |
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 385062 399869 411884 411895 413711 415230 415617 416015 420131 420185 420351 420762 423332 445623 447888 448542 449695 450965 451240 453813 454109 456429 456706 457332 457630 459870 460085 462637 465498 467837 468608 468827 470197 470252 471316 471398 471814 472620 474772 475242 476901 478995 479798 479846 480633 485066 489184 490036 494731 497907 501714 502306 502487 503855 504176 506360 507712 510114 510839 511484 512479 512790 517119 517689 517824 518644 518745 519769 521033 523211 523782 523811 525124 528568 529373 534575 540562 542541 550611 553971 556423 558414 558786 560212 564656 566068 567587 568335 568835 585428 585945 586511 588288 590327 592602 593109 599556 601662 605301 606744 607309 607705 618036 620619 621426 631173 634131 641690 650028 677674 678052 680944 696128 714748 722691 724504 785126 788132 805739 815268 ] |
||||||||||||||||||||||||||||||
|
17.00 ms (8.90%) |
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 470252 680944 512479 534575 601662 420762 411895 445623 525124 474772 805739 618036 631173 415617 467837 475242 479846 550611 459870 450965 457332 592602 385062 542541 511484 468608 567587 607309 420131 454109 490036 722691 399869 506360 586511 517119 471316 480633 468827 472620 416015 471398 449695 523811 457630 494731 607705 415230 593109 413711 451240 556423 485066 517689 605301 785126 502487 478995 460085 519769 517824 528568 696128 590327 634131 448542 420185 507712 523211 471814 510114 566068 503855 564656 606744 456429 411884 588288 529373 620619 504176 476901 465498 553971 714748 462637 568335 650028 788132 479798 518745 815268 560212 540562 423332 510839 724504 558786 456706 641690 453813 502306 678052 677674 447888 518644 621426 420351 558414 501714 470197 489184 523782 512790 497907 568835 585428 585945 599556 521033 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.29%) |
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 385062 399869 411884 411895 413711 415230 415617 416015 420131 420185 420351 420762 423332 445623 447888 448542 449695 450965 451240 453813 454109 456429 456706 457332 457630 459870 460085 462637 465498 467837 468608 468827 470197 470252 471316 471398 471814 472620 474772 475242 476901 478995 479798 479846 480633 485066 489184 490036 494731 497907 501714 502306 502487 503855 504176 506360 507712 510114 510839 511484 512479 512790 517119 517689 517824 518644 518745 519769 521033 523211 523782 523811 525124 528568 529373 534575 540562 542541 550611 553971 556423 558414 558786 560212 564656 566068 567587 568335 568835 585428 585945 586511 588288 590327 592602 593109 599556 601662 605301 606744 607309 607705 618036 620619 621426 631173 634131 641690 650028 677674 678052 680944 696128 714748 722691 724504 785126 788132 805739 815268 ] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"thick cock blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"thick cock минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.22 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"thick cock минет оральн секс"
]
|
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.