Query Metrics
7
Database Queries
7
Different statements
176.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.07 ms (81.98%) |
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 390935 398306 398954 398998 402969 418226 423515 423953 426798 427095 427907 428098 428148 432681 432731 433701 433767 435378 435883 436335 436859 441669 441910 441996 444943 445993 446315 448431 450739 453640 454368 455587 455745 455835 457195 457599 462172 463162 464039 465269 465771 468919 469106 469831 470195 470833 471431 473699 474364 475562 478841 479119 480314 481410 482827 483741 483854 485594 492169 492420 493352 495194 499950 501040 503323 503743 507435 509252 511501 511846 512588 513010 513377 516353 518438 519446 519624 523606 524423 525412 529485 560240 565673 565936 568085 577450 577819 584638 586431 587536 592979 594875 596823 597015 597282 603388 604375 606958 608230 616716 620097 622833 623078 625001 627522 640888 670089 748624 749907 751597 751603 754081 762817 765453 778575 783154 792223 795316 799453 825917 ] |
||||||||||||||||||||||||||||||
|
22.08 ms (12.48%) |
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 577819 587536 594875 616716 623078 620097 627522 778575 792223 799453 751603 754081 765453 749907 751597 762817 748624 783154 795316 398998 462172 469106 470195 473699 475562 398306 423515 433767 455745 468919 479119 398954 423953 435378 435883 390935 402969 426798 427095 432681 433701 436335 444943 450739 453640 454368 470833 478841 480314 481410 441669 445993 457195 503323 483741 483854 493352 513377 519624 525412 492420 507435 509252 511501 523606 524423 499950 513010 516353 519446 584638 577450 670089 603388 608230 592979 597015 625001 463162 640888 825917 428098 436859 441910 427907 455587 471431 465269 469831 464039 503743 495194 560240 432731 418226 441996 457599 465771 428148 455835 511846 482827 485594 512588 565936 568085 446315 448431 501040 565673 596823 597282 622833 586431 604375 606958 474364 492169 518438 529485 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (1.76%) |
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 390935 398306 398954 398998 402969 418226 423515 423953 426798 427095 427907 428098 428148 432681 432731 433701 433767 435378 435883 436335 436859 441669 441910 441996 444943 445993 446315 448431 450739 453640 454368 455587 455745 455835 457195 457599 462172 463162 464039 465269 465771 468919 469106 469831 470195 470833 471431 473699 474364 475562 478841 479119 480314 481410 482827 483741 483854 485594 492169 492420 493352 495194 499950 501040 503323 503743 507435 509252 511501 511846 512588 513010 513377 516353 518438 519446 519624 523606 524423 525412 529485 560240 565673 565936 568085 577450 577819 584638 586431 587536 592979 594875 596823 597015 597282 603388 604375 606958 608230 616716 620097 622833 623078 625001 627522 640888 670089 748624 749907 751597 751603 754081 762817 765453 778575 783154 792223 795316 799453 825917 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bitch wife"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"женскийрод жен"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.