Query Metrics
7
Database Queries
7
Different statements
189.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.73 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 6663 197472 382591 395625 396786 400932 401240 405990 413392 414133 419509 420774 423350 425495 427879 436796 437344 441032 441454 442544 443239 443262 443433 444109 446861 447235 447688 448176 450088 450894 453103 454581 459581 460299 461437 468355 468802 468828 468850 469195 469505 469931 473510 473891 474806 475308 492638 493234 494253 496368 496376 496380 501228 502060 503428 504142 504592 507945 512557 513201 514404 514999 517451 518181 518638 518999 520786 521041 521905 522487 523236 523548 525297 526076 530716 537899 544841 547880 557195 560931 572327 576557 576966 585133 595734 596989 600004 604338 606344 620990 625673 637689 637714 639119 641115 646243 646245 646246 650544 653383 660409 665698 666591 676622 689750 695164 719141 720047 724559 741764 750121 755996 770402 788208 792812 808470 810710 814178 820330 821418 ] |
||||||||||||||||||||||||||||||
|
20.60 ms (10.85%) |
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 468802 468355 522487 523548 401240 447235 382591 444109 814178 821418 646246 560931 788208 641115 474806 396786 469931 420774 820330 468828 473510 525297 572327 595734 637714 755996 808470 468850 523236 512557 526076 448176 450088 606344 639119 792812 517451 405990 441454 442544 473891 646245 695164 653383 604338 625673 469505 518999 414133 437344 413392 443433 441032 492638 459581 518181 530716 496368 518638 521041 650544 666591 600004 750121 741764 427879 520786 521905 504142 395625 6663 585133 469195 460299 547880 544841 576557 719141 689750 596989 770402 810710 443262 454581 496376 496380 507945 443239 646243 576966 620990 453103 557195 475308 514404 660409 197472 423350 425495 537899 502060 503428 504592 676622 724559 419509 501228 514999 493234 400932 436796 446861 494253 665698 720047 637689 447688 450894 461437 513201 ] |
||||||||||||||||||||||||||||||
|
3.50 ms (1.85%) |
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 6663 197472 382591 395625 396786 400932 401240 405990 413392 414133 419509 420774 423350 425495 427879 436796 437344 441032 441454 442544 443239 443262 443433 444109 446861 447235 447688 448176 450088 450894 453103 454581 459581 460299 461437 468355 468802 468828 468850 469195 469505 469931 473510 473891 474806 475308 492638 493234 494253 496368 496376 496380 501228 502060 503428 504142 504592 507945 512557 513201 514404 514999 517451 518181 518638 518999 520786 521041 521905 522487 523236 523548 525297 526076 530716 537899 544841 547880 557195 560931 572327 576557 576966 585133 595734 596989 600004 604338 606344 620990 625673 637689 637714 639119 641115 646243 646245 646246 650544 653383 660409 665698 666591 676622 689750 695164 719141 720047 724559 741764 750121 755996 770402 788208 792812 808470 810710 814178 820330 821418 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pounding ass"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pounding жоп"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pounding жоп"
]
|
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.