Query Metrics
7
Database Queries
7
Different statements
257.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
232.48 ms (90.44%) |
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 325743 392704 397509 403144 441211 444203 476834 505328 508550 511812 516023 521330 524814 531021 539283 540846 541134 541818 544979 546275 547606 548690 548879 548994 550481 551089 551217 551520 551588 551878 552130 552854 555065 555066 557988 558382 559855 560508 560917 563596 566287 566836 567287 567503 567800 567820 568030 571460 571764 572705 575765 576460 578328 579072 581248 581934 582393 583684 584218 584915 585301 585869 587103 587978 588122 588813 589472 590369 590549 591798 593183 593884 594497 595611 595954 596478 598153 598457 599601 603125 604266 609516 609590 620317 621984 623303 632719 635061 639481 646106 648690 652975 653788 658835 659478 661440 662588 665324 669708 669926 672199 672691 674900 684447 685399 691935 692625 692627 695042 698171 704347 726894 727147 729975 758188 780772 796950 801463 806737 812717 ] |
||||||||||||||||||||||||||||||
|
14.46 ms (5.62%) |
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 578328 685399 812717 801463 727147 758188 780772 558382 555065 588813 397509 476834 524814 560917 441211 508550 539283 551878 544979 567287 571460 572705 576460 581248 566287 646106 653788 669926 674900 692625 692627 695042 661440 665324 648690 652975 672199 672691 691935 698171 563596 581934 584218 587978 590369 620317 635061 599601 632719 593183 593884 598153 609590 588122 603125 609516 729975 639481 704347 684447 621984 806737 540846 550481 557988 551520 659478 595611 596478 595954 590549 547606 662588 587103 623303 591798 511812 567503 516023 403144 552130 568030 541134 548994 551588 658835 551089 571764 583684 585869 604266 444203 584915 551217 546275 579072 669708 594497 325743 531021 548690 555066 566836 567800 541818 548879 552854 589472 585301 598457 796950 726894 392704 505328 521330 575765 559855 560508 567820 582393 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.13%) |
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 325743 392704 397509 403144 441211 444203 476834 505328 508550 511812 516023 521330 524814 531021 539283 540846 541134 541818 544979 546275 547606 548690 548879 548994 550481 551089 551217 551520 551588 551878 552130 552854 555065 555066 557988 558382 559855 560508 560917 563596 566287 566836 567287 567503 567800 567820 568030 571460 571764 572705 575765 576460 578328 579072 581248 581934 582393 583684 584218 584915 585301 585869 587103 587978 588122 588813 589472 590369 590549 591798 593183 593884 594497 595611 595954 596478 598153 598457 599601 603125 604266 609516 609590 620317 621984 623303 632719 635061 639481 646106 648690 652975 653788 658835 659478 661440 662588 665324 669708 669926 672199 672691 674900 684447 685399 691935 692625 692627 695042 698171 704347 726894 727147 729975 758188 780772 796950 801463 806737 812717 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny amateur ass"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.73%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые любительск жоп"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые любительск жоп"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.57%) |
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.