Query Metrics
7
Database Queries
7
Different statements
156.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.21 ms (83.10%) |
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 187592 389519 391076 400991 400995 428388 429089 439568 440620 447390 449897 450800 451569 452282 454402 456427 456996 457391 457975 459130 464067 465628 466107 466915 467248 467338 468931 469313 469335 470738 470767 471500 472389 472578 472640 474085 474168 474861 476823 477713 481465 484556 484596 486815 487315 487975 492557 502034 502059 502715 503981 504423 506415 507266 511830 512533 512875 513960 514838 515876 515914 518548 519341 524226 525186 525941 527716 542826 542872 550227 553280 555136 555140 555832 557036 558472 561884 564647 566075 567491 569930 573361 577096 589590 593451 594958 598625 601435 601462 601985 603167 603986 608775 609271 614479 617781 619411 622932 650788 658433 662396 663378 665102 667539 739532 743065 807326 ] |
||||||||||||||||||||||||||||||
|
16.24 ms (10.36%) |
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 457391 474085 474168 481465 391076 451569 464067 471500 470738 472389 503981 507266 601435 513960 452282 466915 486815 502034 569930 400995 465628 467248 484556 487315 515914 187592 457975 454402 477713 512875 514838 472578 487975 566075 561884 542872 665102 598625 603986 593451 617781 807326 609271 456996 428388 459130 470767 439568 472640 476823 449897 450800 518548 502715 515876 525186 492557 466107 601462 400991 429089 467338 474861 502059 550227 555832 667539 555140 567491 573361 619411 608775 743065 469313 468931 389519 447390 484596 504423 524226 527716 557036 440620 456427 506415 519341 555136 663378 589590 739532 525941 512533 564647 650788 603167 614479 577096 469335 511830 662396 658433 542826 622932 594958 601985 558472 553280 ] |
||||||||||||||||||||||||||||||
|
3.70 ms (2.36%) |
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 187592 389519 391076 400991 400995 428388 429089 439568 440620 447390 449897 450800 451569 452282 454402 456427 456996 457391 457975 459130 464067 465628 466107 466915 467248 467338 468931 469313 469335 470738 470767 471500 472389 472578 472640 474085 474168 474861 476823 477713 481465 484556 484596 486815 487315 487975 492557 502034 502059 502715 503981 504423 506415 507266 511830 512533 512875 513960 514838 515876 515914 518548 519341 524226 525186 525941 527716 542826 542872 550227 553280 555136 555140 555832 557036 558472 561884 564647 566075 567491 569930 573361 577096 589590 593451 594958 598625 601435 601462 601985 603167 603986 608775 609271 614479 617781 619411 622932 650788 658433 662396 663378 665102 667539 739532 743065 807326 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"woman парен"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"woman and boy"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"woman парен"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.01%) |
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.