Query Metrics
7
Database Queries
7
Different statements
168.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.32 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 302443 357442 373724 381919 394165 397568 401628 403116 412779 412814 416613 419231 419816 421466 424136 428305 434491 436080 439218 439868 443916 446641 447159 447703 448551 450951 452572 452847 453355 453822 455494 456161 458867 461713 463325 463361 467110 467895 468375 473416 474596 477620 479662 480206 483369 485919 486841 489286 489625 489876 499942 500908 505109 505328 507008 510544 513219 517288 523751 523761 554868 555804 560261 566739 567735 573493 589621 590038 599032 619612 625488 625980 648463 654858 655212 655213 661967 674866 682379 691405 707895 715877 725608 727293 728780 729105 730363 730380 732215 739794 745497 752124 756656 761033 761564 764834 766883 767745 770306 775715 781562 781564 783067 783370 785504 786747 788899 794344 797147 799998 800642 802032 804344 806856 811843 814433 814529 824579 825943 827385 ] |
||||||||||||||||||||||||||||||
|
15.61 ms (9.28%) |
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 357442 573493 434491 447703 447159 461713 474596 480206 555804 567735 463325 443916 458867 455494 473416 486841 523761 483369 489876 500908 412814 416613 450951 452572 453355 560261 619612 730380 446641 394165 421466 419816 439218 499942 554868 707895 661967 674866 781564 802032 766883 728780 715877 397568 448551 467110 452847 453822 507008 468375 489625 401628 419231 424136 467895 412779 428305 436080 456161 505109 510544 485919 505328 513219 523751 439868 302443 648463 463361 373724 814433 825943 827385 814529 824579 477620 489286 517288 566739 655212 682379 691405 654858 655213 589621 590038 599032 625980 625488 800642 729105 745497 761564 781562 783370 811843 727293 756656 767745 761033 770306 725608 732215 739794 752124 730363 764834 775715 783067 785504 786747 794344 797147 799998 804344 806856 381919 403116 788899 479662 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.53%) |
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 302443 357442 373724 381919 394165 397568 401628 403116 412779 412814 416613 419231 419816 421466 424136 428305 434491 436080 439218 439868 443916 446641 447159 447703 448551 450951 452572 452847 453355 453822 455494 456161 458867 461713 463325 463361 467110 467895 468375 473416 474596 477620 479662 480206 483369 485919 486841 489286 489625 489876 499942 500908 505109 505328 507008 510544 513219 517288 523751 523761 554868 555804 560261 566739 567735 573493 589621 590038 599032 619612 625488 625980 648463 654858 655212 655213 661967 674866 682379 691405 707895 715877 725608 727293 728780 729105 730363 730380 732215 739794 745497 752124 756656 761033 761564 764834 766883 767745 770306 775715 781562 781564 783067 783370 785504 786747 788899 794344 797147 799998 800642 802032 804344 806856 811843 814433 814529 824579 825943 827385 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam anal teen"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер анал teen"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер анал teen"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.