Query Metrics
7
Database Queries
7
Different statements
386.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.78 ms (54.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"азиатк pussy"
]
|
||||||||||||||||||||||||||||||
|
148.59 ms (38.45%) |
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 2571 168596 386786 389243 397072 397510 405911 409949 410132 415847 420206 422949 425694 428450 428458 428728 431716 432337 435611 443216 445081 446855 448859 452434 452442 452530 454857 457102 458341 461487 463264 463752 467705 469210 471970 473539 476153 478025 482330 486830 492815 493858 498620 500271 504722 505369 507290 507670 510043 510575 510577 512172 516291 519905 523222 524639 525099 525193 525197 537732 540186 544405 545532 548730 549319 550735 551952 552001 554071 554418 554428 554432 557199 559864 559883 560216 561888 562872 564789 565213 565473 578420 583633 585373 586935 588614 590925 590944 598344 600460 600623 600631 622650 628167 653247 654369 666075 686082 695183 702075 717299 718606 720299 720948 727334 731497 737129 738909 748634 748665 749478 768086 782770 785571 793919 797070 812841 825259 828321 ] |
||||||||||||||||||||||||||||||
|
18.51 ms (4.79%) |
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 428728 415847 448859 463752 446855 452442 454857 492815 525193 500271 505369 510577 507290 461487 559864 565213 552001 557199 578420 545532 702075 653247 654369 686082 549319 565473 600623 585373 590944 588614 727334 768086 731497 622650 720948 469210 482330 457102 409949 425694 471970 523222 525197 512172 828321 473539 516291 486830 564789 583633 559883 785193 737129 431716 476153 493858 510575 551952 748665 168596 825259 666075 718606 782770 797070 717299 428458 432337 519905 561888 628167 478025 422949 410132 420206 507670 720299 793919 785571 2571 397072 405911 435611 452530 554432 600631 590925 812841 738909 748634 397510 463264 544405 586935 749478 386786 389243 428450 443216 445081 467705 452434 458341 524639 498620 504722 537732 510043 540186 525099 554428 560216 554418 548730 550735 562872 695183 554071 598344 600460 ] |
||||||||||||||||||||||||||||||
|
3.74 ms (0.97%) |
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 2571 168596 386786 389243 397072 397510 405911 409949 410132 415847 420206 422949 425694 428450 428458 428728 431716 432337 435611 443216 445081 446855 448859 452434 452442 452530 454857 457102 458341 461487 463264 463752 467705 469210 471970 473539 476153 478025 482330 486830 492815 493858 498620 500271 504722 505369 507290 507670 510043 510575 510577 512172 516291 519905 523222 524639 525099 525193 525197 537732 540186 544405 545532 548730 549319 550735 551952 552001 554071 554418 554428 554432 557199 559864 559883 560216 561888 562872 564789 565213 565473 578420 583633 585373 586935 588614 590925 590944 598344 600460 600623 600631 622650 628167 653247 654369 666075 686082 695183 702075 717299 718606 720299 720948 727334 731497 737129 738909 748634 748665 749478 768086 782770 785571 793919 797070 812841 825259 828321 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (0.60%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк pussy"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian pussy"
]
|
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.