Query Metrics
7
Database Queries
7
Different statements
203.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.80 ms (87.40%) |
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 67006 233346 384779 391966 391982 392032 393862 398676 398678 398794 398984 400719 401952 411339 413473 421831 422146 425692 426810 426814 426908 426919 427064 427083 435537 435922 438858 443817 443986 446813 448376 458059 460554 460907 461541 462277 464673 465033 467350 470151 473580 475182 476365 480004 480430 480886 481244 482832 483971 485377 487470 490328 491889 493089 495483 496236 500402 501652 501797 502907 504161 506741 510098 510383 511518 511750 512293 512702 513441 513685 521012 522817 524044 524439 524690 524708 524775 525438 534147 538414 540245 543685 543823 547052 548686 552324 552415 552463 552977 560558 564217 568954 570321 571565 571854 572168 573001 575212 576095 576348 586379 588822 590591 595480 596411 596618 597503 597811 623402 659423 659621 673908 675355 676537 720652 736120 743170 754104 755634 802080 ] |
||||||||||||||||||||||||||||||
|
16.09 ms (7.91%) |
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 736120 460554 511518 401952 570321 564217 623402 427064 464673 398678 510383 524044 506741 588822 427083 513685 501652 524439 543685 597811 568954 552977 480886 480430 534147 438858 501797 465033 500402 426810 524775 548686 596618 461541 525438 411339 398794 590591 475182 512293 538414 502907 676537 426919 435922 483971 540245 413473 510098 495483 512702 513441 521012 482832 675355 392032 597503 422146 421831 524690 576095 552415 586379 426908 573001 575212 426814 448376 487470 571854 743170 755634 233346 560558 571565 572168 493089 552324 596411 443817 659423 595480 67006 659621 802080 443986 384779 398676 490328 393862 473580 543823 754104 460907 480004 458059 511750 470151 425692 446813 476365 485377 576348 391982 462277 467350 481244 522817 496236 491889 524708 400719 673908 391966 504161 398984 435537 552463 547052 720652 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.25%) |
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 67006 233346 384779 391966 391982 392032 393862 398676 398678 398794 398984 400719 401952 411339 413473 421831 422146 425692 426810 426814 426908 426919 427064 427083 435537 435922 438858 443817 443986 446813 448376 458059 460554 460907 461541 462277 464673 465033 467350 470151 473580 475182 476365 480004 480430 480886 481244 482832 483971 485377 487470 490328 491889 493089 495483 496236 500402 501652 501797 502907 504161 506741 510098 510383 511518 511750 512293 512702 513441 513685 521012 522817 524044 524439 524690 524708 524775 525438 534147 538414 540245 543685 543823 547052 548686 552324 552415 552463 552977 560558 564217 568954 570321 571565 571854 572168 573001 575212 576095 576348 586379 588822 590591 595480 596411 596618 597503 597811 623402 659423 659621 673908 675355 676537 720652 736120 743170 754104 755634 802080 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian brunette минет"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск черноволосая минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.72%) |
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.