Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`

[]

SELECT
  `lang_id`,
  `code`,
  `name`,
  `icon`
FROM
  `lang`

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`;

SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1

[
  "asian beauty massage"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?
LIMIT
  1

SELECT `trend_id` FROM `trend` WHERE `subject` = 'asian beauty massage' LIMIT 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  386953
  653254
  23670
  743038
  397477
  419115
  583213
  390219
  406578
  800268
  625915
  773024
  742993
  622644
  816830
  756359
  401485
  382957
  759782
  538333
  818390
  636926
  772394
  653247
  639310
  431427
  720943
  510043
  405203
  528066
  741631
  603576
  542944
  653253
  814806
  558383
  797788
  721368
  525208
  415623
  531903
  586590
  463867
  565946
  522014
  610247
  574644
  643415
  552198
  820070
  643738
  789760
  367863
  784613
  508485
  510589
  651611
  421235
  577048
  591278
  643072
  643411
  510571
  556415
  532255
  815096
  592750
  819975
  584797
  625928
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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`=1 LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=2 WHERE p.post_id IN (386953, 653254, 23670, 743038, 397477, 419115, 583213, 390219, 406578, 800268, 625915, 773024, 742993, 622644, 816830, 756359, 401485, 382957, 759782, 538333, 818390, 636926, 772394, 653247, 639310, 431427, 720943, 510043, 405203, 528066, 741631, 603576, 542944, 653253, 814806, 558383, 797788, 721368, 525208, 415623, 531903, 586590, 463867, 565946, 522014, 610247, 574644, 643415, 552198, 820070, 643738, 789760, 367863, 784613, 508485, 510589, 651611, 421235, 577048, 591278, 643072, 643411, 510571, 556415, 532255, 815096, 592750, 819975, 584797, 625928);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  23670
  367863
  382957
  386953
  390219
  397477
  401485
  405203
  406578
  415623
  419115
  421235
  431427
  463867
  508485
  510043
  510571
  510589
  522014
  525208
  528066
  531903
  532255
  538333
  542944
  552198
  556415
  558383
  565946
  574644
  577048
  583213
  584797
  586590
  591278
  592750
  603576
  610247
  622644
  625915
  625928
  636926
  639310
  643072
  643411
  643415
  643738
  651611
  653247
  653253
  653254
  720943
  721368
  741631
  742993
  743038
  756359
  759782
  772394
  773024
  784613
  789760
  797788
  800268
  814806
  815096
  816830
  818390
  819975
  820070
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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=1 LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=2 WHERE pht.post_id IN (23670, 367863, 382957, 386953, 390219, 397477, 401485, 405203, 406578, 415623, 419115, 421235, 431427, 463867, 508485, 510043, 510571, 510589, 522014, 525208, 528066, 531903, 532255, 538333, 542944, 552198, 556415, 558383, 565946, 574644, 577048, 583213, 584797, 586590, 591278, 592750, 603576, 610247, 622644, 625915, 625928, 636926, 639310, 643072, 643411, 643415, 643738, 651611, 653247, 653253, 653254, 720943, 721368, 741631, 742993, 743038, 756359, 759782, 772394, 773024, 784613, 789760, 797788, 800268, 814806, 815096, 816830, 818390, 819975, 820070);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  23670
  367863
  382957
  386953
  390219
  397477
  401485
  405203
  406578
  415623
  419115
  421235
  431427
  463867
  508485
  510043
  510571
  510589
  522014
  525208
  528066
  531903
  532255
  538333
  542944
  552198
  556415
  558383
  565946
  574644
  577048
  583213
  584797
  586590
  591278
  592750
  603576
  610247
  622644
  625915
  625928
  636926
  639310
  643072
  643411
  643415
  643738
  651611
  653247
  653253
  653254
  720943
  721368
  741631
  742993
  743038
  756359
  759782
  772394
  773024
  784613
  789760
  797788
  800268
  814806
  815096
  816830
  818390
  819975
  820070
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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=1 LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=2 WHERE phc.post_id IN (23670, 367863, 382957, 386953, 390219, 397477, 401485, 405203, 406578, 415623, 419115, 421235, 431427, 463867, 508485, 510043, 510571, 510589, 522014, 525208, 528066, 531903, 532255, 538333, 542944, 552198, 556415, 558383, 565946, 574644, 577048, 583213, 584797, 586590, 591278, 592750, 603576, 610247, 622644, 625915, 625928, 636926, 639310, 643072, 643411, 643415, 643738, 651611, 653247, 653253, 653254, 720943, 721368, 741631, 742993, 743038, 756359, 759782, 772394, 773024, 784613, 789760, 797788, 800268, 814806, 815096, 816830, 818390, 819975, 820070);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "азиатк beauty массаж"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'азиатк beauty массаж';

SELECT `trend_id` FROM `trend` WHERE `subject` = ?

[
  "азиатк beauty массаж"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?

SELECT `trend_id` FROM `trend` WHERE `subject` = 'азиатк beauty массаж';

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?

[
  "asian beauty massage"
  "asian beauty massage"
  "asian beauty massage"
  20
]

SELECT
  `query_id`,
  `cover`,
  `query`,
  MATCH (`query`) AGAINST (?) AS `relevance`
FROM
  `search_log`
WHERE
  MATCH (`query`) AGAINST (?)
  AND `query` <> ?
  AND `blocked` = 0
ORDER BY
  `relevance` DESC
LIMIT
  ?

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST ('asian beauty massage') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('asian beauty massage')
              AND `query` <> 'asian beauty massage'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;