Query Metrics
7
Database Queries
7
Different statements
366.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.23 ms (58.17%) |
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 20180 233018 389117 391472 391583 398969 398970 399829 400847 400851 400998 401008 401470 401749 401807 402897 405501 406711 411333 411336 411361 411421 411912 418883 419095 419655 420087 422523 422546 422671 423015 424427 425957 426665 428138 428890 430287 433322 434286 434325 439593 439608 441209 443422 443720 448532 454208 458311 460179 461620 464753 465348 466136 466168 466310 466350 467404 467461 467489 467502 467514 467519 470148 470199 470288 470954 470956 476256 477975 479034 481124 481929 484429 485346 490879 490884 490917 491144 491704 491993 497422 509918 511598 523205 532338 537916 539462 544489 546713 549764 550744 554105 559552 563141 565372 566075 566076 569245 589619 590330 601337 608505 608550 610600 619520 622387 623203 633718 636593 637427 651669 667895 688586 697892 698102 721014 744355 789968 811037 814857 ] |
||||||||||||||||||||||||||||||
|
128.75 ms (35.13%) |
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 20180 233018 389117 391472 391583 398969 398970 399829 400847 400851 400998 401008 401470 401749 401807 402897 405501 406711 411333 411336 411361 411421 411912 418883 419095 419655 420087 422523 422546 422671 423015 424427 425957 426665 428138 428890 430287 433322 434286 434325 439593 439608 441209 443422 443720 448532 454208 458311 460179 461620 464753 465348 466136 466168 466310 466350 467404 467461 467489 467502 467514 467519 470148 470199 470288 470954 470956 476256 477975 479034 481124 481929 484429 485346 490879 490884 490917 491144 491704 491993 497422 509918 511598 523205 532338 537916 539462 544489 546713 549764 550744 554105 559552 563141 565372 566075 566076 569245 589619 590330 601337 608505 608550 610600 619520 622387 623203 633718 636593 637427 651669 667895 688586 697892 698102 721014 744355 789968 811037 814857 ] |
||||||||||||||||||||||||||||||
|
18.17 ms (4.96%) |
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 697892 667895 549764 563141 569245 601337 622387 590330 608505 608550 789968 619520 811037 233018 400851 401470 411333 419655 420087 479034 411336 426665 434325 441209 443720 467519 391472 391583 433322 439608 466350 470148 476256 20180 389117 402897 406711 422523 425957 428138 443422 448532 464753 481929 411361 419095 466136 466168 509918 484429 490884 491704 491993 511598 490879 485346 490917 491144 430287 497422 537916 523205 470288 550744 688586 633718 637427 623203 466310 400847 401807 405501 422671 422546 423015 814857 461620 454208 470954 532338 539462 546713 566075 544489 554105 559552 566076 651669 721014 565372 636593 589619 744355 610600 698102 428890 470199 470956 477975 481124 398970 400998 401008 401749 439593 458311 460179 465348 467489 398969 399829 411421 411912 418883 424427 434286 467404 467461 467502 467514 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pantyhose young"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pantyhose young"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pantyhose young"
]
|
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.