Query Metrics
7
Database Queries
7
Different statements
158.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.28 ms (80.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 5565 54301 96503 152508 210355 312919 384373 384972 385316 385674 387325 387785 389560 397579 397664 398543 399563 400715 400987 404185 409984 411823 414226 424419 426394 427181 427770 427949 429941 443044 445024 447773 448568 454421 456721 456937 459096 460550 470214 470461 472580 474451 475395 476995 481466 482039 484413 488293 489032 490306 490310 491447 491790 495238 497025 519161 519717 524245 545531 557787 566231 568025 580393 585410 589824 591594 593098 593144 594853 596322 603340 609551 612329 623147 635786 638302 649586 651794 663438 663921 663964 667897 669754 675956 677270 678221 684977 693322 693388 695151 709309 715698 724628 728172 734693 734725 738901 740545 740965 747607 755203 755411 761385 763349 764524 768884 769158 771211 771867 776651 790664 795409 797240 797262 799503 801408 808238 813578 818999 821294 ] |
||||||||||||||||||||||||||||||
|
20.38 ms (12.85%) |
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 818999 821294 210355 385674 568025 448568 456937 470214 519161 454421 476995 470461 491447 495238 524245 385316 400715 580393 400987 429941 490306 409984 426394 813578 557787 545531 663438 667897 669754 675956 678221 695151 651794 663921 677270 684977 596322 635786 638302 594853 603340 593098 589824 593144 776651 795409 799503 808238 734693 747607 761385 764524 769158 797240 797262 728172 740545 771211 768884 734725 738901 740965 755411 771867 709309 801408 152508 404185 424419 491790 612329 475395 460550 497025 427949 649586 459096 482039 489032 566231 663964 591594 474451 384373 387325 387785 490310 715698 481466 427770 519717 312919 389560 397664 472580 447773 397579 411823 384972 54301 96503 398543 445024 443044 427181 693388 693322 623147 585410 609551 763349 790664 724628 755203 414226 5565 399563 484413 488293 456721 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.77%) |
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 5565 54301 96503 152508 210355 312919 384373 384972 385316 385674 387325 387785 389560 397579 397664 398543 399563 400715 400987 404185 409984 411823 414226 424419 426394 427181 427770 427949 429941 443044 445024 447773 448568 454421 456721 456937 459096 460550 470214 470461 472580 474451 475395 476995 481466 482039 484413 488293 489032 490306 490310 491447 491790 495238 497025 519161 519717 524245 545531 557787 566231 568025 580393 585410 589824 591594 593098 593144 594853 596322 603340 609551 612329 623147 635786 638302 649586 651794 663438 663921 663964 667897 669754 675956 677270 678221 684977 693322 693388 695151 709309 715698 724628 728172 734693 734725 738901 740545 740965 747607 755203 755411 761385 763349 764524 768884 769158 771211 771867 776651 790664 795409 797240 797262 799503 801408 808238 813578 818999 821294 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"natural tits blonde"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"натуральная натуральные сиськ без силикон беловолосая"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.92%) |
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.