Query Metrics
7
Database Queries
7
Different statements
153.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.30 ms (81.62%) |
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 390898 420591 423946 426433 426777 426806 426836 426841 427086 429231 437742 438971 442558 454677 455280 457418 459708 460739 461644 466124 466705 470523 473286 475378 476391 478940 482913 483253 488138 492703 494148 494202 495772 498198 500176 501772 501795 506436 507193 507220 512495 512658 517125 519073 519713 522498 522813 523871 524607 525311 527329 527821 552193 552210 552463 555933 555993 557972 559518 562194 562278 568349 572037 575164 579188 595507 595854 596412 596423 599531 600489 601630 608347 609248 609268 609274 610694 616856 617613 618476 619223 619520 619920 620644 623003 629766 631302 636270 637444 641011 653458 656067 659394 675705 693307 705226 721427 721487 721721 722751 722851 722871 727400 741279 742404 757549 762514 785761 786428 796925 802588 816736 817782 819921 823165 823647 824612 825826 826481 828664 ] |
||||||||||||||||||||||||||||||
|
18.01 ms (11.73%) |
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 757549 786428 478940 559518 575164 595854 442558 429231 426433 653458 608347 519713 600489 461644 523871 525311 498198 705226 721427 721487 609274 619223 623003 616856 636270 609268 741279 641011 721721 785761 438971 454677 455280 501772 488138 507220 527821 817782 610694 609248 482913 495772 507193 501795 512495 595507 596423 552463 555933 659394 675705 631302 637444 727400 619520 426777 390898 426806 500176 527329 601630 618476 517125 579188 572037 555993 557972 722751 629766 596412 742404 722851 470523 492703 519073 524607 494148 620644 824612 656067 599531 722871 427086 475378 506436 522498 494202 619920 823647 423946 819921 828664 568349 826481 816736 512658 457418 466705 466124 522813 825826 802588 762514 796925 562278 460739 617613 562194 459708 426836 437742 426841 823165 483253 552193 420591 473286 476391 552210 693307 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (2.09%) |
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 390898 420591 423946 426433 426777 426806 426836 426841 427086 429231 437742 438971 442558 454677 455280 457418 459708 460739 461644 466124 466705 470523 473286 475378 476391 478940 482913 483253 488138 492703 494148 494202 495772 498198 500176 501772 501795 506436 507193 507220 512495 512658 517125 519073 519713 522498 522813 523871 524607 525311 527329 527821 552193 552210 552463 555933 555993 557972 559518 562194 562278 568349 572037 575164 579188 595507 595854 596412 596423 599531 600489 601630 608347 609248 609268 609274 610694 616856 617613 618476 619223 619520 619920 620644 623003 629766 631302 636270 637444 641011 653458 656067 659394 675705 693307 705226 721427 721487 721721 722751 722851 722871 727400 741279 742404 757549 762514 785761 786428 796925 802588 816736 817782 819921 823165 823647 824612 825826 826481 828664 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian massage"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск массаж"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск массаж"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.