Query Metrics
7
Database Queries
7
Different statements
199.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.23 ms (85.67%) |
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 95982 311163 389500 390734 395141 395554 397998 400621 404302 407109 407527 407529 407876 411730 411933 411946 416029 421989 422185 426994 428837 429084 432735 432736 439728 439812 443833 443862 451937 453153 453311 455343 462695 464295 465147 465386 465531 466080 466129 469489 475867 477867 477991 479129 479359 480373 481914 482219 482392 483140 483149 485265 485684 490167 490916 491969 492269 493138 496865 496874 499362 501556 502814 504668 505822 508593 511808 513507 514811 515906 517599 517769 517933 518486 531977 544464 558894 561409 563197 563443 573468 589661 591276 591281 603743 606728 610271 628648 634858 641082 651186 663990 665199 667266 667546 667845 696426 721167 726753 740284 742560 746107 755810 758171 771023 780620 780930 782153 788275 789363 800936 803665 807538 807553 810069 815677 815758 816558 816951 820228 ] |
||||||||||||||||||||||||||||||
|
17.13 ms (8.57%) |
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 480373 95982 422185 477991 696426 407876 451937 455343 485265 485684 531977 499362 667266 439812 416029 511808 411946 482392 479129 453311 508593 483140 563443 466080 395141 665199 667845 663990 628648 780620 469489 482219 816558 591281 755810 395554 518486 514811 389500 496865 462695 479359 788275 807553 807538 397998 400621 407529 432736 573468 443862 491969 558894 465531 404302 606728 641082 746107 820228 815677 561409 789363 421989 517769 544464 517599 515906 411933 517933 771023 589661 505822 407527 428837 466129 490167 603743 501556 667546 490916 439728 496874 502814 390734 465386 429084 481914 465147 513507 483149 492269 443833 407109 610271 426994 311163 411730 464295 475867 477867 453153 504668 800936 810069 726753 815758 816951 651186 721167 591276 782153 742560 740284 758171 780930 803665 432735 493138 563197 634858 ] |
||||||||||||||||||||||||||||||
|
4.23 ms (2.11%) |
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 95982 311163 389500 390734 395141 395554 397998 400621 404302 407109 407527 407529 407876 411730 411933 411946 416029 421989 422185 426994 428837 429084 432735 432736 439728 439812 443833 443862 451937 453153 453311 455343 462695 464295 465147 465386 465531 466080 466129 469489 475867 477867 477991 479129 479359 480373 481914 482219 482392 483140 483149 485265 485684 490167 490916 491969 492269 493138 496865 496874 499362 501556 502814 504668 505822 508593 511808 513507 514811 515906 517599 517769 517933 518486 531977 544464 558894 561409 563197 563443 573468 589661 591276 591281 603743 606728 610271 628648 634858 641082 651186 663990 665199 667266 667546 667845 696426 721167 726753 740284 742560 746107 755810 758171 771023 780620 780930 782153 788275 789363 800936 803665 807538 807553 810069 815677 815758 816558 816951 820228 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ðÀÐÇðÁð╗ð░ÐÅ ð© ð┐ð░ÐÇðÁð¢Ðî ð▓ ð┤ÐâÐêð%ÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"зрелая женщин парен ван"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.67%) |
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.