Query Metrics
7
Database Queries
7
Different statements
151.95 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.77 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.92 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"monster cock cock"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.03 ms |
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 640785 756406 785421 733883 756775 761275 733838 733843 622392 786461 811643 457974 458922 463262 413235 458675 391537 536872 463087 196316 359918 388628 396699 416611 420381 423434 455914 464621 473836 485471 491788 458919 511499 525077 540305 513737 536613 581274 545532 680816 704715 680164 680179 689689 716778 565275 597260 607376 590173 600118 613859 778069 810825 745785 602300 423435 476796 478700 486058 515481 419906 428514 419653 459237 461673 482821 531239 524400 534161 503353 571999 581083 565274 579629 676080 678109 679317 700291 579633 590174 633750 623931 633987 733867 733888 733891 700294 458916 445022 465008 430275 475703 491276 519392 415223 537771 500931 465103 554445 542216 571303 647847 676633 679733 696996 650179 632975 628376 597139 628392 598656 733884 733886 733879 632692 641949 447560 511497 396395 399058 ] |
||||||||||||||||||||||||||||||
| 4 | 2.78 ms |
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 196316 359918 388628 391537 396395 396699 399058 413235 415223 416611 419653 419906 420381 423434 423435 428514 430275 445022 447560 455914 457974 458675 458916 458919 458922 459237 461673 463087 463262 464621 465008 465103 473836 475703 476796 478700 482821 485471 486058 491276 491788 500931 503353 511497 511499 513737 515481 519392 524400 525077 531239 534161 536613 536872 537771 540305 542216 545532 554445 565274 565275 571303 571999 579629 579633 581083 581274 590173 590174 597139 597260 598656 600118 602300 607376 613859 622392 623931 628376 628392 632692 632975 633750 633987 640785 641949 647847 650179 676080 676633 678109 679317 679733 680164 680179 680816 689689 696996 700291 700294 704715 716778 733838 733843 733867 733879 733883 733884 733886 733888 733891 745785 756406 756775 761275 778069 785421 786461 810825 811643 ] |
||||||||||||||||||||||||||||||
| 5 | 127.30 ms |
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 196316 359918 388628 391537 396395 396699 399058 413235 415223 416611 419653 419906 420381 423434 423435 428514 430275 445022 447560 455914 457974 458675 458916 458919 458922 459237 461673 463087 463262 464621 465008 465103 473836 475703 476796 478700 482821 485471 486058 491276 491788 500931 503353 511497 511499 513737 515481 519392 524400 525077 531239 534161 536613 536872 537771 540305 542216 545532 554445 565274 565275 571303 571999 579629 579633 581083 581274 590173 590174 597139 597260 598656 600118 602300 607376 613859 622392 623931 628376 628392 632692 632975 633750 633987 640785 641949 647847 650179 676080 676633 678109 679317 679733 680164 680179 680816 689689 696996 700291 700294 704715 716778 733838 733843 733867 733879 733883 733884 733886 733888 733891 745785 756406 756775 761275 778069 785421 786461 810825 811643 ] |
||||||||||||||||||||||||||||||
| 6 | 1.62 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"monster cock cock"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.53 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"monster cock cock"
]
|
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.