Query Metrics
7
Database Queries
7
Different statements
378.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
348.21 ms (91.97%) |
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 340635 382207 382502 389966 391984 391992 405105 405252 407759 407878 408695 417737 418853 419572 419956 420280 420311 421199 426294 429267 429902 441354 443554 447837 453390 454140 454210 458332 459195 460336 460368 462962 463973 463976 464017 464987 465431 466860 467062 467837 469285 469393 472421 473533 475662 475680 476241 476325 476347 476356 481467 484373 484762 485724 487049 487057 489250 495243 495279 508254 509218 509225 509598 509637 510233 511670 519136 519148 519625 522181 522448 523622 525992 527476 529356 543591 554408 554490 554793 557327 563903 565742 566743 567418 568152 569271 570713 576006 578528 578796 579585 580521 581937 582603 589670 592064 595158 599648 599657 602753 605579 605588 605601 607218 618622 664186 665288 666188 724470 728469 731378 748463 757724 761293 766709 781857 799180 804427 808166 811736 ] |
||||||||||||||||||||||||||||||
|
19.04 ms (5.03%) |
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 580521 419956 476347 465431 454210 522448 509218 618622 417737 382207 418853 509598 523622 476325 554793 570713 554490 582603 565742 569271 664186 666188 554408 607218 589670 804427 808166 811736 757724 761293 728469 602753 781857 340635 391984 429902 453390 454140 472421 408695 464017 420311 489250 519625 441354 576006 463973 443554 557327 525992 463976 421199 469285 487057 527476 460368 595158 405252 391992 407878 419572 426294 464987 459195 487049 447837 458332 475662 476241 476356 485724 511670 495243 519136 519148 529356 509225 522181 578528 578796 581937 543591 563903 665288 566743 568152 599648 605579 605601 592064 599657 799180 748463 724470 731378 766709 429267 475680 382502 467837 407759 467062 481467 484373 389966 462962 405105 420280 605588 460336 473533 469393 484762 495279 508254 509637 510233 466860 579585 567418 ] |
||||||||||||||||||||||||||||||
|
3.55 ms (0.94%) |
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 340635 382207 382502 389966 391984 391992 405105 405252 407759 407878 408695 417737 418853 419572 419956 420280 420311 421199 426294 429267 429902 441354 443554 447837 453390 454140 454210 458332 459195 460336 460368 462962 463973 463976 464017 464987 465431 466860 467062 467837 469285 469393 472421 473533 475662 475680 476241 476325 476347 476356 481467 484373 484762 485724 487049 487057 489250 495243 495279 508254 509218 509225 509598 509637 510233 511670 519136 519148 519625 522181 522448 523622 525992 527476 529356 543591 554408 554490 554793 557327 563903 565742 566743 567418 568152 569271 570713 576006 578528 578796 579585 580521 581937 582603 589670 592064 595158 599648 599657 602753 605579 605588 605601 607218 618622 664186 665288 666188 724470 728469 731378 748463 757724 761293 766709 781857 799180 804427 808166 811736 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (0.57%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"chubby девушк волосатая"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"chubby girl hairy"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"chubby девушк волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.47%) |
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.