Query Metrics
7
Database Queries
7
Different statements
145.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.66 ms (82.18%) |
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 131497 159305 381734 417830 420462 421840 421843 421862 422182 422207 428138 428383 430526 439704 439756 443911 445620 452006 453598 454153 455090 455641 461827 462558 463323 465773 469587 472859 474586 476932 477556 485084 487352 487882 489871 496220 496353 499936 504970 506073 508187 508276 510071 511955 514445 521129 523836 523838 524486 532221 535373 535453 538006 544499 549224 555380 557987 559071 563010 563025 563171 563173 563643 569012 579045 580438 585282 591042 591977 602199 604276 606299 619484 645273 645283 646293 648517 649198 653854 655833 662129 669514 673353 673365 687119 690810 694554 695276 696355 700281 705057 707316 712325 715497 716205 725197 726306 726827 726847 726923 728386 732917 738519 740318 761066 770133 775473 790867 796970 802357 806327 807194 813084 814223 814625 815050 817843 818450 820770 824177 ] |
||||||||||||||||||||||||||||||
|
16.40 ms (11.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 813084 775473 802357 806327 725197 726827 726847 732917 726306 726923 740318 770133 738519 761066 619484 790867 807194 421843 454153 421862 461827 131497 474586 381734 422182 428138 445620 455641 508276 521129 523836 489871 523838 535453 485084 504970 510071 579045 645273 606299 796970 728386 511955 420462 814223 477556 487882 508187 496220 496353 472859 563025 563173 569012 559071 563171 549224 563010 563643 591977 602199 604276 585282 591042 421840 422207 439756 465773 452006 159305 417830 439704 453598 469587 538006 506073 514445 524486 430526 443911 428383 820770 824177 814625 815050 817843 818450 455090 487352 462558 476932 532221 499936 535373 463323 544499 557987 555380 580438 645283 646293 648517 662129 673353 695276 707316 715497 716205 649198 653854 669514 690810 694554 696355 700281 705057 712325 655833 673365 687119 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.56%) |
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 131497 159305 381734 417830 420462 421840 421843 421862 422182 422207 428138 428383 430526 439704 439756 443911 445620 452006 453598 454153 455090 455641 461827 462558 463323 465773 469587 472859 474586 476932 477556 485084 487352 487882 489871 496220 496353 499936 504970 506073 508187 508276 510071 511955 514445 521129 523836 523838 524486 532221 535373 535453 538006 544499 549224 555380 557987 559071 563010 563025 563171 563173 563643 569012 579045 580438 585282 591042 591977 602199 604276 606299 619484 645273 645283 646293 648517 649198 653854 655833 662129 669514 673353 673365 687119 690810 694554 695276 696355 700281 705057 707316 712325 715497 716205 725197 726306 726827 726847 726923 728386 732917 738519 740318 761066 770133 775473 790867 796970 802357 806327 807194 813084 814223 814625 815050 817843 818450 820770 824177 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.34%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"condom анал"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"condom in anal"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"condom анал"
]
|
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.