Query Metrics
7
Database Queries
7
Different statements
158.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.58 ms (82.78%) |
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 393241 393483 395809 416819 417011 417408 418860 420696 421050 423808 425668 428076 431727 436135 439158 442063 442434 442796 444465 444581 444919 445874 447444 447532 448561 453357 453427 453538 454599 455840 457045 459958 460619 461725 462087 463519 464753 465608 465797 466549 467725 468741 471872 476419 479204 480109 483279 483691 483882 485290 485527 490464 490530 492133 493562 494094 495740 496782 498264 499406 500344 500455 501557 501674 502626 505090 505626 506082 506239 508385 509978 512245 512991 514451 515444 518552 518557 518805 519183 519283 519969 520071 520817 521637 524443 525190 525330 526346 528831 529225 531656 533643 544090 545321 553629 553931 561361 564967 566939 569414 570149 572327 572690 578413 581483 582071 583687 589108 590277 590788 591673 595125 598700 635838 661989 696774 720424 765807 780821 823767 ] |
||||||||||||||||||||||||||||||
|
16.99 ms (10.69%) |
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 564967 428076 464753 508385 526346 506239 505090 490530 553629 720424 502626 544090 417011 823767 500344 572690 498264 490464 448561 519183 518557 454599 590788 417408 453357 493562 425668 765807 393483 395809 459958 566939 465797 483691 524443 590277 420696 471872 453427 519969 476419 518552 518805 561361 591673 595125 436135 505626 525330 494094 445874 453538 462087 442063 418860 468741 520071 545321 635838 467725 500455 583687 598700 439158 485290 501674 582071 533643 515444 483882 431727 466549 465608 444581 553931 499406 423808 506082 444919 447444 529225 496782 461725 485527 572327 519283 525190 479204 581483 528831 457045 460619 483279 661989 480109 421050 447532 442434 495740 512245 514451 492133 589108 531656 570149 393241 509978 442796 569414 696774 520817 416819 578413 780821 501557 444465 455840 521637 463519 512991 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.58%) |
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 393241 393483 395809 416819 417011 417408 418860 420696 421050 423808 425668 428076 431727 436135 439158 442063 442434 442796 444465 444581 444919 445874 447444 447532 448561 453357 453427 453538 454599 455840 457045 459958 460619 461725 462087 463519 464753 465608 465797 466549 467725 468741 471872 476419 479204 480109 483279 483691 483882 485290 485527 490464 490530 492133 493562 494094 495740 496782 498264 499406 500344 500455 501557 501674 502626 505090 505626 506082 506239 508385 509978 512245 512991 514451 515444 518552 518557 518805 519183 519283 519969 520071 520817 521637 524443 525190 525330 526346 528831 529225 531656 533643 544090 545321 553629 553931 561361 564967 566939 569414 570149 572327 572690 578413 581483 582071 583687 589108 590277 590788 591673 595125 598700 635838 661989 696774 720424 765807 780821 823767 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girls big ass"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.05%) |
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.