Query Metrics
7
Database Queries
7
Different statements
161.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.50 ms (83.05%) |
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 17190 120497 381854 384452 388290 388566 389389 389788 390593 390670 392534 395373 397353 412832 413189 413685 417366 418053 424384 434874 454534 456156 458920 492280 499243 508204 512306 514892 536266 545717 558846 560261 568169 572331 574605 574889 575109 575477 588231 589318 594109 594162 594289 594430 594503 595446 597005 598084 598537 598553 600104 607761 609645 609884 610346 619171 629598 634159 641950 645202 654460 659324 659432 663231 665714 667129 674980 677348 678125 684902 690516 699403 700470 714567 719640 720159 720164 720967 722899 727773 731984 735085 735930 737298 737553 740373 740651 743391 744270 747574 749329 750727 752721 753290 753294 753302 753340 753800 753898 753902 756073 756687 758887 762972 765278 772991 777138 777652 779706 786963 788540 796731 797389 799785 800575 800587 805669 814019 818860 819677 ] |
||||||||||||||||||||||||||||||
|
18.01 ms (11.12%) |
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 752721 753290 753294 762972 749329 753898 750727 753902 756687 727773 753340 756073 699403 714567 720159 777652 779706 800587 413189 384452 536266 545717 575109 674980 678125 641950 120497 381854 17190 389788 390593 390670 412832 417366 818860 819677 814019 456156 499243 492280 572331 654460 665714 690516 722899 645202 659432 659324 663231 629598 595446 594162 594430 600104 786963 796731 800575 799785 735930 737553 740373 740651 743391 753302 753800 772991 788540 805669 744270 735085 737298 747574 758887 765278 731984 609645 719640 777138 797389 388290 397353 458920 388566 389389 395373 418053 512306 508204 589318 594503 594289 392534 667129 720967 413685 434874 424384 454534 514892 560261 568169 575477 574889 558846 574605 684902 677348 700470 720164 634159 597005 598084 598553 619171 594109 598537 607761 609884 610346 588231 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.67%) |
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 17190 120497 381854 384452 388290 388566 389389 389788 390593 390670 392534 395373 397353 412832 413189 413685 417366 418053 424384 434874 454534 456156 458920 492280 499243 508204 512306 514892 536266 545717 558846 560261 568169 572331 574605 574889 575109 575477 588231 589318 594109 594162 594289 594430 594503 595446 597005 598084 598537 598553 600104 607761 609645 609884 610346 619171 629598 634159 641950 645202 654460 659324 659432 663231 665714 667129 674980 677348 678125 684902 690516 699403 700470 714567 719640 720159 720164 720967 722899 727773 731984 735085 735930 737298 737553 740373 740651 743391 744270 747574 749329 750727 752721 753290 753294 753302 753340 753800 753898 753902 756073 756687 758887 762972 765278 772991 777138 777652 779706 786963 788540 796731 797389 799785 800575 800587 805669 814019 818860 819677 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм teen"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sperm teen"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм teen"
]
|
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.