Query Metrics
7
Database Queries
7
Different statements
390.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
224.05 ms (57.41%) |
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 736784 714888 739164 766608 415827 796157 730342 657159 711728 583539 777195 795299 742723 397592 555267 794895 766220 759571 559401 818542 791924 441780 726887 433353 425450 728517 598088 801269 725142 759927 585214 3671 781590 784313 422207 795297 479071 468343 451499 738000 447022 764595 794915 425601 797218 441782 777728 799910 457240 718119 495223 812722 492293 765792 764148 716090 549102 674307 496975 639355 827431 724123 543532 778424 776981 765227 493775 475901 719929 536995 554576 727738 440781 506069 566980 391087 131512 733548 612927 720065 460585 726282 472592 779804 775640 730391 768392 566405 718102 425531 777750 715549 788371 776922 761579 733284 726989 680284 588393 502718 391251 492009 504038 476172 477128 493172 680312 748971 400487 401491 441845 777953 797206 468357 729907 430526 560005 420333 446525 705471 ] |
||||||||||||||||||||||||||||||
|
155.66 ms (39.88%) |
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 3671 131512 391087 391251 397592 400487 401491 415827 420333 422207 425450 425531 425601 430526 433353 440781 441780 441782 441845 446525 447022 451499 457240 460585 468343 468357 472592 475901 476172 477128 479071 492009 492293 493172 493775 495223 496975 502718 504038 506069 536995 543532 549102 554576 555267 559401 560005 566405 566980 583539 585214 588393 598088 612927 639355 657159 674307 680284 680312 705471 711728 714888 715549 716090 718102 718119 719929 720065 724123 725142 726282 726887 726989 727738 728517 729907 730342 730391 733284 733548 736784 738000 739164 742723 748971 759571 759927 761579 764148 765227 765792 766220 766608 768392 775640 776922 776981 777195 777728 777750 777953 778424 779804 781590 784313 788371 791924 794895 794915 795297 795299 796157 797206 797218 799910 801269 812722 818542 827431 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (0.65%) |
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 3671 131512 391087 391251 397592 400487 401491 415827 420333 422207 425450 425531 425601 430526 433353 440781 441780 441782 441845 446525 447022 451499 457240 460585 468343 468357 472592 475901 476172 477128 479071 492009 492293 493172 493775 495223 496975 502718 504038 506069 536995 543532 549102 554576 555267 559401 560005 566405 566980 583539 585214 588393 598088 612927 639355 657159 674307 680284 680312 705471 711728 714888 715549 716090 718102 718119 719929 720065 724123 725142 726282 726887 726989 727738 728517 729907 730342 730391 733284 733548 736784 738000 739164 742723 748971 759571 759927 761579 764148 765227 765792 766220 766608 768392 775640 776922 776981 777195 777728 777750 777953 778424 779804 781590 784313 788371 791924 794895 794915 795297 795299 796157 797206 797218 799910 801269 812722 818542 827431 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (0.55%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс мам женщин домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс с мамой дома"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.