Query Metrics
7
Database Queries
7
Different statements
180.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.43 ms (86.10%) |
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 389821 419013 423767 435290 435746 438312 449039 451307 455339 455471 456857 460548 462272 463168 464268 465481 467227 467368 467494 467810 470340 470716 472038 475008 478340 478753 479394 481849 482927 483256 484124 485429 485485 487372 488512 491721 495678 498827 498855 503798 503920 504152 504185 504351 505477 506718 506786 508588 521963 522514 525565 534105 544725 548780 551030 552862 555973 556449 559035 574580 582592 584784 587443 589014 593512 594987 595601 595884 598557 598772 598781 601277 601551 608833 609402 610595 614417 614979 647255 659197 673533 674516 674620 689956 690748 696070 696178 705020 705399 709484 721241 725441 731164 735687 737465 740096 744368 745193 758158 761603 761637 768939 771658 777900 779607 779624 780328 783531 784200 784228 785127 788120 788416 788428 799712 801675 804422 806212 811876 813761 ] |
||||||||||||||||||||||||||||||
|
15.79 ms (8.75%) |
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 690748 696070 705020 709484 673533 551030 593512 587443 780328 784228 785127 788120 799712 801675 740096 768939 608833 705399 438312 455339 389821 478340 559035 556449 584784 696178 582592 595884 598781 614979 811876 761603 614417 779624 806212 451307 449039 488512 491721 482927 522514 574580 455471 470716 462272 463168 503798 525565 498827 771658 610595 813761 487372 467227 534105 544725 674620 647255 674516 721241 595601 598772 589014 784200 788428 761637 735687 744368 737465 788416 470340 479394 419013 467810 467368 464268 465481 508588 521963 503920 555973 548780 435746 485485 484124 472038 552862 659197 689956 601277 594987 598557 609402 777900 745193 783531 725441 758158 731164 779607 804422 475008 506786 601551 456857 467494 423767 435290 460548 481849 478753 504185 504351 506718 498855 505477 483256 485429 495678 504152 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.32%) |
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 389821 419013 423767 435290 435746 438312 449039 451307 455339 455471 456857 460548 462272 463168 464268 465481 467227 467368 467494 467810 470340 470716 472038 475008 478340 478753 479394 481849 482927 483256 484124 485429 485485 487372 488512 491721 495678 498827 498855 503798 503920 504152 504185 504351 505477 506718 506786 508588 521963 522514 525565 534105 544725 548780 551030 552862 555973 556449 559035 574580 582592 584784 587443 589014 593512 594987 595601 595884 598557 598772 598781 601277 601551 608833 609402 610595 614417 614979 647255 659197 673533 674516 674620 689956 690748 696070 696178 705020 705399 709484 721241 725441 731164 735687 737465 740096 744368 745193 758158 761603 761637 768939 771658 777900 779607 779624 780328 783531 784200 784228 785127 788120 788416 788428 799712 801675 804422 806212 811876 813761 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian girl hidden"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск девушк скрыт"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.