Query Metrics
7
Database Queries
7
Different statements
168.58 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.76 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.01 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beauty girls masturbation"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.16 ms |
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 495546 535336 560898 434102 506197 515016 709182 589346 783303 414252 820853 749119 398475 554547 562574 764797 529825 639310 523060 811094 471904 659585 646043 705078 808041 728978 744057 409811 650760 696143 731691 411161 466308 781122 791116 783269 731656 774142 785755 646329 778730 786792 724821 414241 402936 823163 530470 490169 683284 801892 156487 588871 662994 783393 777705 754717 790227 754708 755098 773159 760662 213010 411150 559811 676483 594381 805213 743245 774824 411167 389266 476778 547801 579271 557869 572268 765852 419455 457092 498061 500438 487548 512552 521485 483523 487844 566632 663815 710523 591948 812869 795413 726154 759490 765863 751571 763726 765815 770041 752637 602298 805154 806391 813921 530926 533562 534734 650344 600028 630233 782675 809297 798611 753621 752860 715843 446534 820793 656392 643118 ] |
||||||||||||||||||||||||||||||
| 4 | 3.18 ms |
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 156487 213010 389266 398475 402936 409811 411150 411161 411167 414241 414252 419455 434102 446534 457092 466308 471904 476778 483523 487548 487844 490169 495546 498061 500438 506197 512552 515016 521485 523060 529825 530470 530926 533562 534734 535336 547801 554547 557869 559811 560898 562574 566632 572268 579271 588871 589346 591948 594381 600028 602298 630233 639310 643118 646043 646329 650344 650760 656392 659585 662994 663815 676483 683284 696143 705078 709182 710523 715843 724821 726154 728978 731656 731691 743245 744057 749119 751571 752637 752860 753621 754708 754717 755098 759490 760662 763726 764797 765815 765852 765863 770041 773159 774142 774824 777705 778730 781122 782675 783269 783303 783393 785755 786792 790227 791116 795413 798611 801892 805154 805213 806391 808041 809297 811094 812869 813921 820793 820853 823163 ] |
||||||||||||||||||||||||||||||
| 5 | 143.10 ms |
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 156487 213010 389266 398475 402936 409811 411150 411161 411167 414241 414252 419455 434102 446534 457092 466308 471904 476778 483523 487548 487844 490169 495546 498061 500438 506197 512552 515016 521485 523060 529825 530470 530926 533562 534734 535336 547801 554547 557869 559811 560898 562574 566632 572268 579271 588871 589346 591948 594381 600028 602298 630233 639310 643118 646043 646329 650344 650760 656392 659585 662994 663815 676483 683284 696143 705078 709182 710523 715843 724821 726154 728978 731656 731691 743245 744057 749119 751571 752637 752860 753621 754708 754717 755098 759490 760662 763726 764797 765815 765852 765863 770041 773159 774142 774824 777705 778730 781122 782675 783269 783303 783393 785755 786792 790227 791116 795413 798611 801892 805154 805213 806391 808041 809297 811094 812869 813921 820793 820853 823163 ] |
||||||||||||||||||||||||||||||
| 6 | 2.09 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"beauty девушк мастурбац"
]
|
||||||||||||||||||||||||||||||
| 7 | 2.28 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"beauty девушк мастурбац"
]
|
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.