Query Metrics
7
Database Queries
7
Different statements
156.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.50 ms (81.73%) |
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 403137 407115 411071 417246 418920 420217 420836 422241 423642 424753 425083 427173 432294 432656 432876 434854 435165 438206 440414 440710 441314 441664 442197 442944 444604 445632 446176 449280 449696 449709 449931 450149 451503 451643 452271 452351 452822 452827 453147 453205 454388 454474 455023 456058 456418 456691 456807 456931 456939 457379 457524 457843 457961 458079 459352 459521 459778 459914 460145 461709 461757 462422 462948 463358 463590 463602 464234 464364 464805 465911 466813 469230 469349 469420 470644 471036 471121 471656 473325 474931 475685 476670 477891 478005 479691 481025 481711 482014 482443 482739 482769 485857 487557 489782 489897 490403 491126 493543 493679 493758 494102 495000 496750 503988 505191 511218 512079 515550 519852 522339 523603 524631 528564 528851 529674 534651 534673 535031 540012 824584 ] |
||||||||||||||||||||||||||||||
|
17.15 ms (10.99%) |
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 403137 420836 427173 432656 434854 435165 438206 441314 441664 418920 420217 422241 432294 440414 442944 407115 424753 425083 432876 442197 423642 440710 444604 411071 417246 824584 482443 449280 449696 449931 451503 452827 454474 456418 456939 457379 457524 457961 461709 462948 463358 466813 469230 469420 470644 471121 474931 476670 479691 482769 493543 445632 446176 449709 451643 453205 455023 456807 458079 459352 459778 460145 464805 465911 469349 471036 471656 473325 478005 481025 482014 482739 485857 489782 489897 490403 493679 450149 452271 452351 452822 453147 454388 456058 456691 456931 457843 459521 459914 461757 462422 463590 464364 475685 477891 481711 487557 491126 493758 495000 522339 523603 529674 534651 535031 503988 505191 519852 494102 511218 512079 515550 528851 496750 524631 528564 534673 540012 463602 464234 ] |
||||||||||||||||||||||||||||||
|
3.93 ms (2.52%) |
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 403137 407115 411071 417246 418920 420217 420836 422241 423642 424753 425083 427173 432294 432656 432876 434854 435165 438206 440414 440710 441314 441664 442197 442944 444604 445632 446176 449280 449696 449709 449931 450149 451503 451643 452271 452351 452822 452827 453147 453205 454388 454474 455023 456058 456418 456691 456807 456931 456939 457379 457524 457843 457961 458079 459352 459521 459778 459914 460145 461709 461757 462422 462948 463358 463590 463602 464234 464364 464805 465911 466813 469230 469349 469420 470644 471036 471121 471656 473325 474931 475685 476670 477891 478005 479691 481025 481711 482014 482443 482739 482769 485857 487557 489782 489897 490403 491126 493543 493679 493758 494102 495000 496750 503988 505191 511218 512079 515550 519852 522339 523603 524631 528564 528851 529674 534651 534673 535031 540012 824584 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.36%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife naked"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен голые"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.96%) |
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.