Query Metrics
7
Database Queries
7
Different statements
171.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.79 ms (84.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 418497 420924 421357 423465 425523 430625 430629 435452 435697 442318 442835 444400 446148 446863 447182 448669 449356 449666 449888 450794 452404 452987 457034 459271 461079 463199 465080 467839 468629 472004 472208 472935 477895 478107 478834 481874 481878 482770 483250 486539 487750 490996 492196 492229 492319 492325 492994 495813 501875 504989 505843 507078 507439 507540 509561 510622 512851 518547 520801 521447 521582 523040 527003 527005 527006 527301 528084 528100 531415 531508 531512 534567 537282 537520 542676 549226 558132 569179 569211 569302 569304 571257 571833 575324 575853 579669 581069 581715 582433 582797 584752 587416 588190 588231 589573 592229 594007 596534 596966 598154 600965 601317 603949 605615 606762 607518 609794 618523 619843 630766 636925 641059 644070 660030 668472 675157 791048 800641 820871 822673 ] |
||||||||||||||||||||||||||||||
|
17.74 ms (10.35%) |
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 449666 459271 483250 450794 468629 467839 510622 531508 528100 531415 537282 518547 521582 465080 472935 571833 579669 582433 582797 668472 549226 571257 575324 592229 587416 600965 618523 603949 605615 644070 609794 430629 472004 477895 461079 420924 421357 478107 478834 481874 449888 435697 463199 520801 523040 492196 501875 507540 509561 527003 504989 800641 418497 444400 481878 446148 569179 584752 598154 472208 527006 507078 425523 675157 636925 641059 447182 542676 527301 521447 660030 588231 606762 452987 581069 588190 596966 594007 601317 446863 492994 492325 537520 490996 435452 442835 820871 822673 487750 457034 534567 531512 569211 569302 569304 581715 607518 589573 596534 630766 452404 449356 512851 486539 492229 492319 430625 528084 575853 619843 527005 505843 495813 442318 448669 558132 791048 423465 482770 507439 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.32%) |
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 418497 420924 421357 423465 425523 430625 430629 435452 435697 442318 442835 444400 446148 446863 447182 448669 449356 449666 449888 450794 452404 452987 457034 459271 461079 463199 465080 467839 468629 472004 472208 472935 477895 478107 478834 481874 481878 482770 483250 486539 487750 490996 492196 492229 492319 492325 492994 495813 501875 504989 505843 507078 507439 507540 509561 510622 512851 518547 520801 521447 521582 523040 527003 527005 527006 527301 528084 528100 531415 531508 531512 534567 537282 537520 542676 549226 558132 569179 569211 569302 569304 571257 571833 575324 575853 579669 581069 581715 582433 582797 584752 587416 588190 588231 589573 592229 594007 596534 596966 598154 600965 601317 603949 605615 606762 607518 609794 618523 619843 630766 636925 641059 644070 660030 668472 675157 791048 800641 820871 822673 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy ass pov"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая жоп пов"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.77%) |
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.