Query Metrics
7
Database Queries
7
Different statements
607.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
416.89 ms (68.63%) |
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 115206 370557 412173 413592 415115 415534 417202 417746 419729 422330 424379 428052 430796 433644 435744 443097 444994 445106 445897 446970 448426 448574 449371 449914 452037 452608 453522 454788 456814 458632 460098 461904 462450 462601 462734 462805 466599 467810 468590 469524 469931 471186 471307 472090 472334 474615 474972 479998 480895 485585 485586 487020 487069 487472 488730 489609 490007 490008 490734 491594 491882 492099 492244 493402 494784 494843 495003 495103 495448 495686 500056 502218 502346 502598 505683 506477 508780 509360 510817 512323 513697 513747 513983 514018 514318 515371 515434 515522 516196 516360 516929 517590 517960 518219 519876 520306 521522 522501 522926 523299 523533 523655 523859 523969 523996 524614 525140 525216 525850 525854 527172 527710 531464 543195 552467 814753 815624 816267 821383 821532 ] |
||||||||||||||||||||||||||||||
|
163.49 ms (26.91%) |
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 115206 370557 412173 413592 415115 415534 417202 417746 419729 422330 424379 428052 430796 433644 435744 443097 444994 445106 445897 446970 448426 448574 449371 449914 452037 452608 453522 454788 456814 458632 460098 461904 462450 462601 462734 462805 466599 467810 468590 469524 469931 471186 471307 472090 472334 474615 474972 479998 480895 485585 485586 487020 487069 487472 488730 489609 490007 490008 490734 491594 491882 492099 492244 493402 494784 494843 495003 495103 495448 495686 500056 502218 502346 502598 505683 506477 508780 509360 510817 512323 513697 513747 513983 514018 514318 515371 515434 515522 516196 516360 516929 517590 517960 518219 519876 520306 521522 522501 522926 523299 523533 523655 523859 523969 523996 524614 525140 525216 525850 525854 527172 527710 531464 543195 552467 814753 815624 816267 821383 821532 ] |
||||||||||||||||||||||||||||||
|
19.58 ms (3.22%) |
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 460098 462601 467810 471186 472334 474972 428052 458632 462734 462805 472090 474615 479998 449371 468590 469524 469931 480895 446970 456814 502218 506477 512323 513747 514318 516360 521522 523655 523969 488730 489609 490008 495003 502346 505683 508780 510817 515434 515522 516929 517960 523299 487020 487069 491594 491882 494843 500056 509360 513983 517590 524614 525216 485585 485586 490007 490734 492244 495103 495448 514018 516196 522501 523533 525140 520306 462450 525854 370557 448574 452608 454788 445897 449914 452037 461904 502598 527710 495686 522926 531464 519876 543195 552467 413592 415115 422330 453522 444994 466599 471307 448426 518219 513697 515371 525850 487472 492099 493402 494784 523859 523996 527172 115206 417746 430796 412173 415534 445106 433644 424379 435744 417202 419729 443097 814753 821383 815624 816267 821532 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"white leggings"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (0.34%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"white лосин"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"white лосин"
]
|
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.