Query Metrics
7
Database Queries
7
Different statements
354.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.42 ms (58.82%) |
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 55349 187171 326289 383390 390447 402876 407458 419147 439775 440838 440913 440914 443470 451506 453832 454541 456995 457004 457842 458891 460330 466164 470264 471458 474182 477454 482456 483193 485698 487987 488968 491110 495814 496949 499556 499899 502813 503483 504008 506068 509620 509651 511107 513131 516013 516288 517517 520206 520684 524134 524858 525269 536442 539208 539360 549658 550377 554501 556778 558019 561356 563012 564926 566854 577107 579177 579198 582966 591800 598128 598849 598862 603340 613576 620211 620307 643993 653395 655132 659945 660292 674087 681237 700930 707196 714534 714608 724794 725228 727771 731165 732911 738203 742575 742751 746121 747129 748812 759902 759920 765220 765322 766707 780745 784206 786459 788187 788338 789957 791543 792136 794850 795142 799290 800429 800725 801264 805005 808236 813578 ] |
||||||||||||||||||||||||||||||
|
123.83 ms (34.95%) |
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 55349 187171 326289 383390 390447 402876 407458 419147 439775 440838 440913 440914 443470 451506 453832 454541 456995 457004 457842 458891 460330 466164 470264 471458 474182 477454 482456 483193 485698 487987 488968 491110 495814 496949 499556 499899 502813 503483 504008 506068 509620 509651 511107 513131 516013 516288 517517 520206 520684 524134 524858 525269 536442 539208 539360 549658 550377 554501 556778 558019 561356 563012 564926 566854 577107 579177 579198 582966 591800 598128 598849 598862 603340 613576 620211 620307 643993 653395 655132 659945 660292 674087 681237 700930 707196 714534 714608 724794 725228 727771 731165 732911 738203 742575 742751 746121 747129 748812 759902 759920 765220 765322 766707 780745 784206 786459 788187 788338 789957 791543 792136 794850 795142 799290 800429 800725 801264 805005 808236 813578 ] |
||||||||||||||||||||||||||||||
|
15.13 ms (4.27%) |
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 456995 503483 525269 577107 655132 747129 765220 55349 509651 495814 390447 402876 419147 440914 440913 440838 485698 513131 558019 561356 407458 453832 439775 466164 383390 502813 509620 556778 516013 524858 566854 598849 613576 598128 457842 477454 491110 187171 460330 454541 488968 471458 506068 524134 536442 516288 539360 499899 517517 549658 564926 550377 554501 579177 579198 582966 681237 591800 766707 727771 765322 759920 732911 458891 326289 451506 483193 443470 813578 457004 474182 470264 487987 496949 511107 539208 499556 504008 520206 520684 482456 563012 659945 660292 674087 707196 653395 700930 714534 714608 620307 603340 598862 620211 643993 780745 786459 788187 799290 788338 789957 792136 800725 801264 805005 746121 784206 791543 794850 795142 800429 808236 724794 738203 759902 725228 731165 742575 742751 748812 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature sperm cum"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature сперм cum"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature сперм cum"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.44%) |
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.