Query Metrics
7
Database Queries
7
Different statements
177.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.81 ms (82.25%) |
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 383086 390680 401936 413929 413971 418013 418423 421394 422512 423245 423893 424351 427950 428315 428570 429759 434642 434822 435462 436314 439151 439845 440654 441016 444859 445493 446300 447158 447315 452317 452681 457130 457140 457143 457500 461456 461729 463096 464193 467195 468779 469023 469751 469756 470256 474301 476137 476430 476649 480306 485083 490036 492170 492829 496269 499354 501225 501329 501958 506800 508541 510588 513662 514071 514241 514820 514999 516291 516350 517330 517788 519530 519556 523333 523442 524388 525044 525303 527975 530709 531351 533517 536668 539783 540608 543107 551275 557449 560212 565254 567453 567605 569260 569692 583132 583448 586504 591345 593656 595510 596627 596880 597232 597253 597263 597963 604608 615762 624175 627809 627813 632979 648871 659418 676025 676523 677002 680116 716892 720836 ] |
||||||||||||||||||||||||||||||
|
21.17 ms (11.94%) |
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 441016 470256 474301 401936 439151 480306 440654 444859 452681 428570 457130 457143 469751 476430 514999 517330 523333 525303 506800 519530 523442 499354 513662 485083 501225 597963 595510 596627 383086 390680 423245 421394 435462 463096 461729 467195 452317 536668 533517 540608 530709 539783 514071 551275 583448 557449 583132 543107 567453 569692 676523 720836 676025 648871 591345 604608 597253 597263 593656 615762 627813 418013 436314 445493 446300 476137 434642 457140 418423 429759 447158 468779 413971 447315 469756 434822 464193 476649 492829 490036 514241 469023 492170 501329 501958 565254 569260 677002 659418 680116 560212 567605 586504 627809 597232 632979 596880 624175 716892 423893 439845 461456 457500 427950 510588 516350 496269 524388 525044 531351 508541 413929 424351 428315 422512 519556 527975 514820 516291 517788 ] |
||||||||||||||||||||||||||||||
|
3.55 ms (2.00%) |
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 383086 390680 401936 413929 413971 418013 418423 421394 422512 423245 423893 424351 427950 428315 428570 429759 434642 434822 435462 436314 439151 439845 440654 441016 444859 445493 446300 447158 447315 452317 452681 457130 457140 457143 457500 461456 461729 463096 464193 467195 468779 469023 469751 469756 470256 474301 476137 476430 476649 480306 485083 490036 492170 492829 496269 499354 501225 501329 501958 506800 508541 510588 513662 514071 514241 514820 514999 516291 516350 517330 517788 519530 519556 523333 523442 524388 525044 525303 527975 530709 531351 533517 536668 539783 540608 543107 551275 557449 560212 565254 567453 567605 569260 569692 583132 583448 586504 591345 593656 595510 596627 596880 597232 597253 597263 597963 604608 615762 624175 627809 627813 632979 648871 659418 676025 676523 677002 680116 716892 720836 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"babe teen"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"babe teen"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"babe teen"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.