Query Metrics
7
Database Queries
7
Different statements
182.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.19 ms (83.95%) |
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 385377 389208 410642 410808 413888 415419 416233 417344 418747 418833 419773 421219 424675 425800 428404 428854 429459 431913 433391 439626 440598 445652 446402 447890 452241 454448 454658 455479 455508 455767 456633 456706 457103 457564 457884 463858 464094 465512 469649 474066 475473 475776 475923 477465 478966 483473 485265 488198 491955 492050 492121 493221 493222 501119 504769 508273 509981 510951 511345 512491 514980 515840 516350 517651 518865 520995 521863 524300 524427 524524 524635 525745 528083 528168 529250 533996 534239 535016 535452 543342 548490 551407 558249 563289 564901 574460 577491 586564 586590 588297 588525 589656 590866 597126 598199 598649 598741 599951 601655 601748 603756 605409 607087 607094 607797 607870 611986 612348 613836 617641 619884 620232 621269 622184 622805 623251 624171 650224 653233 680824 ] |
||||||||||||||||||||||||||||||
|
19.89 ms (10.90%) |
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 599951 603756 607087 607797 611986 598199 617641 623251 621269 624171 457103 477465 428854 469649 521863 524427 534239 485265 511345 518865 501119 517651 491955 524524 385377 419773 421219 428404 433391 410808 418747 418833 454658 455508 456633 488198 563289 543342 653233 588297 586590 439626 455479 456706 457564 417344 425800 440598 447890 452241 454448 463858 445652 528168 524300 529250 512491 535452 548490 613836 424675 413888 455767 457884 465512 446402 464094 508273 475923 493222 558249 551407 574460 601748 607870 598741 588525 597126 601655 607094 619884 389208 431913 475776 475473 410642 429459 474066 478966 416233 504769 524635 483473 493221 509981 516350 520995 492050 492121 510951 528083 564901 650224 680824 577491 598649 589656 590866 612348 620232 586564 605409 622184 622805 415419 533996 514980 525745 535016 515840 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.49%) |
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 385377 389208 410642 410808 413888 415419 416233 417344 418747 418833 419773 421219 424675 425800 428404 428854 429459 431913 433391 439626 440598 445652 446402 447890 452241 454448 454658 455479 455508 455767 456633 456706 457103 457564 457884 463858 464094 465512 469649 474066 475473 475776 475923 477465 478966 483473 485265 488198 491955 492050 492121 493221 493222 501119 504769 508273 509981 510951 511345 512491 514980 515840 516350 517651 518865 520995 521863 524300 524427 524524 524635 525745 528083 528168 529250 533996 534239 535016 535452 543342 548490 551407 558249 563289 564901 574460 577491 586564 586590 588297 588525 589656 590866 597126 598199 598649 598741 599951 601655 601748 603756 605409 607087 607094 607797 607870 611986 612348 613836 617641 619884 620232 621269 622184 622805 623251 624171 650224 653233 680824 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"шикарные женскийрод"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"сочными суками"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.82%) |
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.