Query Metrics
7
Database Queries
7
Different statements
190.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.28 ms (86.23%) |
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 117073 383825 391059 393107 401786 418836 424654 425176 429083 430801 433910 434900 444371 445680 445929 446858 447230 451585 452413 453774 457013 457035 457877 459235 459471 460591 461655 462630 462936 463214 463238 466197 467378 469253 472378 472883 474380 475335 475579 479551 479877 479959 481796 482603 484689 485551 485706 486232 491083 491424 495244 498658 499350 501192 501747 502660 503423 504307 510048 510912 513700 514210 518329 519160 519737 520509 522298 525158 527388 527477 528394 528849 529259 534663 538390 540149 543215 547781 548670 552079 552565 554904 555203 557406 557994 559974 560529 560857 561002 562324 564424 566475 566740 569576 569826 570043 570243 571582 571585 572128 572168 572456 572919 572992 573077 574497 576285 576703 577901 579320 598370 618845 626378 628515 631697 709786 756522 781780 809361 ] |
||||||||||||||||||||||||||||||
|
16.56 ms (8.69%) |
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 469253 482603 453774 472883 528394 495244 519160 540149 475335 543215 557406 570043 571582 572919 547781 554904 561002 570243 579320 552079 557994 559974 566475 571585 572992 709786 548670 552565 555203 562324 576285 618845 626378 756522 117073 383825 463214 475579 434900 445929 457013 457035 460591 466197 418836 424654 429083 446858 451585 462936 479551 479959 391059 401786 433910 452413 457877 467378 519737 529259 502660 514210 491083 513700 538390 486232 525158 527477 491424 520509 569826 569576 628515 430801 461655 462630 459235 463238 501192 534663 503423 528849 472378 564424 560529 560857 572168 573077 574497 566740 572456 577901 572128 576703 598370 631697 604755 781780 809361 393107 425176 474380 447230 459471 479877 481796 444371 445680 518329 484689 485706 485551 499350 510048 522298 527388 498658 501747 504307 510912 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (1.66%) |
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 117073 383825 391059 393107 401786 418836 424654 425176 429083 430801 433910 434900 444371 445680 445929 446858 447230 451585 452413 453774 457013 457035 457877 459235 459471 460591 461655 462630 462936 463214 463238 466197 467378 469253 472378 472883 474380 475335 475579 479551 479877 479959 481796 482603 484689 485551 485706 486232 491083 491424 495244 498658 499350 501192 501747 502660 503423 504307 510048 510912 513700 514210 518329 519160 519737 520509 522298 525158 527388 527477 528394 528849 529259 534663 538390 540149 543215 547781 548670 552079 552565 554904 555203 557406 557994 559974 560529 560857 561002 562324 564424 566475 566740 569576 569826 570043 570243 571582 571585 572128 572168 572456 572919 572992 573077 574497 576285 576703 577901 579320 598370 618845 626378 628515 631697 709786 756522 781780 809361 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вагин губ"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пизда губы"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.75%) |
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.