Query Metrics
7
Database Queries
7
Different statements
160.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.14 ms (83.07%) |
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 45605 75762 153425 187186 187353 233376 387230 389593 390147 395620 395653 397479 407786 411902 412627 415543 415557 415579 416867 417716 420038 423472 428079 428112 428141 428881 440828 443042 443669 443703 443997 444465 445825 447490 447837 449342 453270 453276 453367 456633 456885 460614 460852 462470 471390 474691 479177 479750 482896 483971 487889 495547 498552 506052 516401 519157 519553 520545 520740 521040 525376 528448 543810 545630 547328 555750 555793 557128 559009 559942 560152 563222 564180 564197 568079 568429 577409 579358 580860 587885 595873 596915 601828 605383 606508 606571 607192 619987 622402 629296 631970 642691 643984 664322 664504 665273 665384 666778 680794 687924 714322 714443 714459 714511 718556 718878 720609 742595 746997 770494 785426 786254 786277 789589 790983 807558 814885 814930 816755 823261 ] |
||||||||||||||||||||||||||||||
|
17.43 ms (10.88%) |
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 395653 516401 395620 390147 447490 456633 543810 557128 579358 559942 560152 559009 568079 601828 807558 444465 521040 520740 187186 75762 387230 397479 423472 443042 407786 417716 428079 411902 428141 816755 453276 449342 453270 479750 498552 547328 564180 545630 555750 568429 665273 680794 664322 665384 718556 664504 666778 714322 714443 718878 555793 563222 564197 587885 607192 619987 631970 643984 790983 770494 786254 789589 742595 746997 714459 720609 785426 786277 45605 153425 443703 453367 233376 479177 389593 440828 443669 412627 420038 443997 482896 525376 487889 495547 520545 462470 506052 580860 577409 714511 687924 606508 629296 595873 606571 642691 605383 596915 622402 456885 416867 528448 519157 519553 187353 415543 415579 415557 428881 428112 814930 814885 823261 445825 460614 460852 471390 474691 483971 447837 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (2.01%) |
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 45605 75762 153425 187186 187353 233376 387230 389593 390147 395620 395653 397479 407786 411902 412627 415543 415557 415579 416867 417716 420038 423472 428079 428112 428141 428881 440828 443042 443669 443703 443997 444465 445825 447490 447837 449342 453270 453276 453367 456633 456885 460614 460852 462470 471390 474691 479177 479750 482896 483971 487889 495547 498552 506052 516401 519157 519553 520545 520740 521040 525376 528448 543810 545630 547328 555750 555793 557128 559009 559942 560152 563222 564180 564197 568079 568429 577409 579358 580860 587885 595873 596915 601828 605383 606508 606571 607192 619987 622402 629296 631970 642691 643984 664322 664504 665273 665384 666778 680794 687924 714322 714443 714459 714511 718556 718878 720609 742595 746997 770494 785426 786254 786277 789589 790983 807558 814885 814930 816755 823261 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young sexy"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young sexy"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young sexy"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.88%) |
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.