Query Metrics
7
Database Queries
7
Different statements
192.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.85 ms (87.84%) |
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 346014 365056 382578 383947 385234 389611 391940 397656 409560 410685 440094 447154 467197 480457 490649 495736 495750 495765 496150 497519 505382 505649 506371 507243 508177 510731 510822 514848 514852 514863 514867 520767 523250 525351 529128 530295 531849 531876 534554 535261 536124 536177 537256 540593 540685 540915 541064 542705 545224 547852 550806 550816 555797 565575 569592 574090 579394 579517 580109 580190 583689 584164 588854 590222 599477 600304 600508 609198 618257 627162 627466 628708 629725 630457 638998 639371 645673 648679 653520 656919 656936 658788 661973 662194 663216 666888 669030 669034 670364 672937 696595 705028 717543 734839 735345 735743 740624 749204 750123 752595 752611 770219 770274 778395 782791 786872 788735 789426 792691 792708 792727 792739 796768 796840 796857 796878 799699 809351 810820 812559 ] |
||||||||||||||||||||||||||||||
|
13.10 ms (6.81%) |
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 799699 735743 749204 505382 514863 490649 510731 505649 508177 514848 628708 599477 440094 735345 529128 496150 670364 590222 630457 523250 346014 536177 580109 705028 645673 618257 629725 792691 796857 810820 752611 792727 661973 812559 531849 541064 696595 796878 740624 385234 536124 550806 480457 542705 497519 565575 656936 648679 627162 786872 750123 495765 525351 540915 382578 514852 495750 569592 609198 627466 391940 389611 537256 531876 534554 574090 666888 658788 796768 792739 662194 383947 365056 410685 495736 510822 663216 540593 669034 672937 600508 638998 639371 792708 734839 809351 409560 530295 506371 540685 656919 547852 600304 796840 447154 579517 550816 507243 535261 583689 669030 653520 579394 555797 467197 545224 584164 717543 588854 778395 752595 770274 789426 770219 782791 788735 520767 580190 514867 397656 ] |
||||||||||||||||||||||||||||||
|
3.36 ms (1.75%) |
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 346014 365056 382578 383947 385234 389611 391940 397656 409560 410685 440094 447154 467197 480457 490649 495736 495750 495765 496150 497519 505382 505649 506371 507243 508177 510731 510822 514848 514852 514863 514867 520767 523250 525351 529128 530295 531849 531876 534554 535261 536124 536177 537256 540593 540685 540915 541064 542705 545224 547852 550806 550816 555797 565575 569592 574090 579394 579517 580109 580190 583689 584164 588854 590222 599477 600304 600508 609198 618257 627162 627466 628708 629725 630457 638998 639371 645673 648679 653520 656919 656936 658788 661973 662194 663216 666888 669030 669034 670364 672937 696595 705028 717543 734839 735345 735743 740624 749204 750123 752595 752611 770219 770274 778395 782791 786872 788735 789426 792691 792708 792727 792739 796768 796840 796857 796878 799699 809351 810820 812559 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girls fisting"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк фистинг"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.83%) |
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.