Query Metrics
7
Database Queries
7
Different statements
173.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.28 ms (87.02%) |
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 381982 389840 398244 411702 411722 424220 424431 426503 442211 452345 458002 465672 467435 469146 470938 475279 480300 482371 482795 484756 486757 490744 491320 510948 513501 515271 517712 520343 523161 529691 532271 533976 534634 534710 540952 544615 547443 549965 557171 560400 569423 569426 569975 571695 573226 573244 574386 580265 580739 583514 584201 584380 586442 586535 588155 589752 601619 601914 603378 603399 604754 605233 607185 607224 617115 618391 625227 641705 650266 650510 661039 663982 665264 669057 669324 669874 673420 678805 695691 705531 715373 716221 725537 736634 741194 741688 741692 741739 742410 747949 748177 755776 757695 759695 759845 759866 770853 771557 771944 784235 788121 789474 789534 797032 798926 799054 799986 800657 800676 802555 803463 808873 811069 815590 819646 820178 823336 824145 824456 826508 ] |
||||||||||||||||||||||||||||||
|
13.08 ms (7.52%) |
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 580739 669324 673420 695691 603399 588155 741688 741692 741739 742410 603378 470938 469146 515271 819646 820178 826508 823336 824145 815590 465672 533976 534634 529691 534710 484756 549965 544615 547443 557171 573244 583514 584201 650510 669874 650266 661039 569975 571695 573226 601619 605233 799986 800676 789474 797032 800657 808873 741194 755776 771944 784235 811069 736634 748177 759866 747949 757695 771557 607224 705531 788121 798926 799054 802555 540952 574386 665264 678805 520343 523161 398244 411702 442211 824456 490744 458002 480300 452345 510948 517712 532271 482371 569423 584380 569426 580265 716221 663982 669057 586442 607185 641705 589752 601914 604754 586535 618391 625227 789534 770853 803463 759845 725537 759695 715373 381982 424431 389840 467435 426503 475279 411722 491320 486757 513501 482795 424220 617115 560400 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.76%) |
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 381982 389840 398244 411702 411722 424220 424431 426503 442211 452345 458002 465672 467435 469146 470938 475279 480300 482371 482795 484756 486757 490744 491320 510948 513501 515271 517712 520343 523161 529691 532271 533976 534634 534710 540952 544615 547443 549965 557171 560400 569423 569426 569975 571695 573226 573244 574386 580265 580739 583514 584201 584380 586442 586535 588155 589752 601619 601914 603378 603399 604754 605233 607185 607224 617115 618391 625227 641705 650266 650510 661039 663982 665264 669057 669324 669874 673420 678805 695691 705531 715373 716221 725537 736634 741194 741688 741692 741739 742410 747949 748177 755776 757695 759695 759845 759866 770853 771557 771944 784235 788121 789474 789534 797032 798926 799054 799986 800657 800676 802555 803463 808873 811069 815590 819646 820178 823336 824145 824456 826508 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"зрелая очки"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"зрелая женщин очкастые"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.32 ms (0.76%) |
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.