Query Metrics
7
Database Queries
7
Different statements
365.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
215.42 ms (58.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк kissing"
]
|
||||||||||||||||||||||||||||||
|
128.42 ms (35.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 261599 390346 418485 444249 472908 473596 484915 490050 490799 512637 521860 527586 532053 534175 535151 537568 544782 569894 570202 570232 570345 570515 570565 570600 571549 572149 572430 573041 573099 573631 573860 574899 575449 584651 596582 621633 628997 631099 652551 652553 652554 653514 654058 654178 654329 654432 657437 659670 659708 665256 665872 667885 668845 670176 670280 670814 671107 671125 671127 671138 673455 673548 673550 673552 673985 675028 675032 675033 675046 679115 679131 681794 684203 685915 692118 694164 701492 705352 709825 717109 719138 722438 723522 723555 724727 730621 730689 731952 736003 737212 737687 740252 740697 741974 742213 743025 743394 744327 746978 747219 747588 748331 750016 753300 753351 753371 753382 753912 754828 775208 782711 784204 787543 795500 800267 816777 817637 818226 819355 819978 ] |
||||||||||||||||||||||||||||||
|
11.91 ms (3.26%) |
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 747219 418485 472908 782711 668845 571549 573099 671107 670176 670280 657437 673552 800267 631099 473596 573041 730689 753371 675032 673550 723555 572149 570345 652553 673548 659708 775208 784204 754828 816777 819355 681794 675033 694164 675046 787543 737687 748331 484915 537568 570600 701492 671127 679115 685915 659670 675028 665256 671125 673455 679131 753300 737212 740252 743394 819978 512637 535151 652551 654058 665872 692118 652554 705352 722438 628997 596582 795500 736003 741974 753351 753382 744327 753912 709825 490050 544782 574899 673985 573860 570565 575449 570232 570202 671138 654432 654178 570515 724727 743025 621633 527586 490799 534175 719138 670814 653514 654329 747588 731952 742213 730621 750016 390346 569894 740697 261599 723522 532053 572430 584651 717109 667885 684203 573631 746978 444249 818226 817637 521860 ] |
||||||||||||||||||||||||||||||
|
3.99 ms (1.09%) |
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 261599 390346 418485 444249 472908 473596 484915 490050 490799 512637 521860 527586 532053 534175 535151 537568 544782 569894 570202 570232 570345 570515 570565 570600 571549 572149 572430 573041 573099 573631 573860 574899 575449 584651 596582 621633 628997 631099 652551 652553 652554 653514 654058 654178 654329 654432 657437 659670 659708 665256 665872 667885 668845 670176 670280 670814 671107 671125 671127 671138 673455 673548 673550 673552 673985 675028 675032 675033 675046 679115 679131 681794 684203 685915 692118 694164 701492 705352 709825 717109 719138 722438 723522 723555 724727 730621 730689 731952 736003 737212 737687 740252 740697 741974 742213 743025 743394 744327 746978 747219 747588 748331 750016 753300 753351 753371 753382 753912 754828 775208 782711 784204 787543 795500 800267 816777 817637 818226 819355 819978 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girls kissing"
]
|
||||||||||||||||||||||||||||||
|
2.21 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк kissing"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.48%) |
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.