ConfigurationLogsProfilingDatabaseEventsMailTimelineDumpRouterRequestUserAsset Bundles
Prev Next
All Latest
680afaaebda76: GET https://sumalepuntoscorporativo.segurosequinoccial.com/2024/producto/index at 2025-04-25 02:59:58 am by 181.39.250.29

Database

41 duplicated queries found.

Database Queries

Total 57 elementos.
TimeDurationTypeDuplicatedQuery
   
02:59:58.7371.0 msSHOW1
SHOW FULL COLUMNS FROM `user`
02:59:58.7390.5 msSELECT1
SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'user' AND `kcu`.`TABLE_NAME` = 'user'

[+] Explain
02:59:58.7450.4 msSELECT1
SELECT * FROM `user` WHERE `id`=1

[+] Explain
02:59:58.7840.5 msSELECT1
SELECT * FROM `auth_assignment` WHERE `user_id`='1'

[+] Explain
02:59:58.7850.4 msSELECT1
SELECT * FROM `auth_item` WHERE `name`='Administrador'

[+] Explain
02:59:58.7900.8 msSHOW1
SHOW FULL COLUMNS FROM `producto`
02:59:58.7910.6 msSELECT1
SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'producto' AND `kcu`.`TABLE_NAME` = 'producto'

[+] Explain
02:59:58.7920.6 msSELECT3
SELECT `b`.* FROM `auth_assignment` `a`, `auth_item` `b` WHERE (`a`.`item_name`=`b`.`name`) AND (`a`.`user_id`='1') AND (`b`.`type`=1)

[+] Explain
02:59:58.7930.4 msSELECT1
SELECT * FROM `categoria` WHERE `padre` IS NULL ORDER BY `nombre`

[+] Explain
02:59:58.7940.6 msSHOW1
SHOW FULL COLUMNS FROM `categoria`
02:59:58.7940.4 msSELECT1
SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'categoria' AND `kcu`.`TABLE_NAME` = 'categoria'

[+] Explain
02:59:58.9471.0 msSELECT1
SELECT COUNT(*) FROM `producto` LEFT JOIN `categoria` ON categoria.id = producto.categoria

[+] Explain
02:59:59.0230.8 msSELECT1
SELECT `producto`.* FROM `producto` LEFT JOIN `categoria` ON categoria.id = producto.categoria LIMIT 20

[+] Explain
02:59:59.1070.4 msSELECT1
SELECT * FROM `proveedor` WHERE `id`=6

[+] Explain
02:59:59.1070.8 msSHOW1
SHOW FULL COLUMNS FROM `proveedor`
02:59:59.1090.7 msSELECT1
SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'proveedor' AND `kcu`.`TABLE_NAME` = 'proveedor'

[+] Explain
02:59:59.1100.4 msSELECT1
SELECT * FROM `categoria` WHERE `id`=3

[+] Explain
02:59:59.1160.4 msSELECT19
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1170.4 msSELECT19
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1230.4 msSELECT19
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1230.3 msSELECT19
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1290.3 msSELECT19
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1290.3 msSELECT19
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1350.4 msSELECT19
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1350.3 msSELECT19
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1400.3 msSELECT19
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1410.3 msSELECT19
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1460.3 msSELECT19
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1460.3 msSELECT19
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1510.3 msSELECT19
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1520.3 msSELECT19
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1560.2 msSELECT19
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1570.2 msSELECT19
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1610.2 msSELECT19
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1620.3 msSELECT19
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1660.3 msSELECT19
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1670.3 msSELECT19
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1710.3 msSELECT19
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1720.3 msSELECT19
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1760.3 msSELECT19
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1760.3 msSELECT19
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1810.3 msSELECT19
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1810.2 msSELECT19
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1850.2 msSELECT19
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1860.3 msSELECT19
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1900.2 msSELECT19
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1900.2 msSELECT19
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1940.2 msSELECT19
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1940.2 msSELECT19
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1980.2 msSELECT19
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1990.2 msSELECT19
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.2020.2 msSELECT19
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.2030.2 msSELECT19
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.2070.2 msSELECT19
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.2070.2 msSELECT19
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.2260.4 msSELECT3
SELECT `b`.* FROM `auth_assignment` `a`, `auth_item` `b` WHERE (`a`.`item_name`=`b`.`name`) AND (`a`.`user_id`='1') AND (`b`.`type`=1)

[+] Explain
02:59:59.2260.3 msSELECT3
SELECT `b`.* FROM `auth_assignment` `a`, `auth_item` `b` WHERE (`a`.`item_name`=`b`.`name`) AND (`a`.`user_id`='1') AND (`b`.`type`=1)

[+] Explain
[+] Explain all

Database Callers

Total 10 elementos.
CallerNo. of CallsTotal DurationQueries
4212.5 ms
Time Duration Queries
02:59:59.1070.4 ms
SELECT * FROM `proveedor` WHERE `id`=6

[+] Explain
02:59:59.1070.8 ms
SHOW FULL COLUMNS FROM `proveedor`
02:59:59.1090.7 ms
SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'proveedor' AND `kcu`.`TABLE_NAME` = 'proveedor'

[+] Explain
02:59:59.1100.4 ms
SELECT * FROM `categoria` WHERE `id`=3

[+] Explain
02:59:59.1160.4 ms
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1170.4 ms
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1230.4 ms
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1230.3 ms
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1290.3 ms
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1290.3 ms
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1350.4 ms
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1350.3 ms
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1400.3 ms
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1410.3 ms
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1460.3 ms
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1460.3 ms
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1510.3 ms
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1520.3 ms
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1560.2 ms
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1570.2 ms
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1610.2 ms
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1620.3 ms
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1660.3 ms
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1670.3 ms
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1710.3 ms
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1720.3 ms
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1760.3 ms
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1760.3 ms
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1810.3 ms
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1810.2 ms
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1850.2 ms
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1860.3 ms
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1900.2 ms
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1900.2 ms
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1940.2 ms
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1940.2 ms
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.1980.2 ms
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.1990.2 ms
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.2020.2 ms
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.2030.2 ms
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
02:59:59.2070.2 ms
SELECT * FROM `proveedor` WHERE `id`=4

[+] Explain
02:59:59.2070.2 ms
SELECT * FROM `categoria` WHERE `id`=1

[+] Explain
31.9 ms
Time Duration Queries
02:59:58.7371.0 ms
SHOW FULL COLUMNS FROM `user`
02:59:58.7390.5 ms
SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'user' AND `kcu`.`TABLE_NAME` = 'user'

[+] Explain
02:59:58.7450.4 ms
SELECT * FROM `user` WHERE `id`=1

[+] Explain
31.5 ms
Time Duration Queries
02:59:58.7930.4 ms
SELECT * FROM `categoria` WHERE `padre` IS NULL ORDER BY `nombre`

[+] Explain
02:59:58.7940.6 ms
SHOW FULL COLUMNS FROM `categoria`
02:59:58.7940.4 ms
SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'categoria' AND `kcu`.`TABLE_NAME` = 'categoria'

[+] Explain
    		20.9 ms
    Time Duration Queries
    02:59:58.7840.5 ms
    SELECT * FROM `auth_assignment` WHERE `user_id`='1'

    [+] Explain
    02:59:58.7850.4 ms
    SELECT * FROM `auth_item` WHERE `name`='Administrador'

    [+] Explain
    21.4 ms
    Time Duration Queries
    02:59:58.7900.8 ms
    SHOW FULL COLUMNS FROM `producto`
    02:59:58.7910.6 ms
    SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'producto' AND `kcu`.`TABLE_NAME` = 'producto'

    [+] Explain
    10.6 ms
    Time Duration Queries
    02:59:58.7920.6 ms
    SELECT `b`.* FROM `auth_assignment` `a`, `auth_item` `b` WHERE (`a`.`item_name`=`b`.`name`) AND (`a`.`user_id`='1') AND (`b`.`type`=1)

    [+] Explain
    11.0 ms
    Time Duration Queries
    02:59:58.9471.0 ms
    SELECT COUNT(*) FROM `producto` LEFT JOIN `categoria` ON categoria.id = producto.categoria

    [+] Explain
    10.8 ms
    Time Duration Queries
    02:59:59.0230.8 ms
    SELECT `producto`.* FROM `producto` LEFT JOIN `categoria` ON categoria.id = producto.categoria LIMIT 20

    [+] Explain
    10.4 ms
    Time Duration Queries
    02:59:59.2260.4 ms
    SELECT `b`.* FROM `auth_assignment` `a`, `auth_item` `b` WHERE (`a`.`item_name`=`b`.`name`) AND (`a`.`user_id`='1') AND (`b`.`type`=1)

    [+] Explain
    10.3 ms
    Time Duration Queries
    02:59:59.2260.3 ms
    SELECT `b`.* FROM `auth_assignment` `a`, `auth_item` `b` WHERE (`a`.`item_name`=`b`.`name`) AND (`a`.`user_id`='1') AND (`b`.`type`=1)

    [+] Explain
    [+] Explain all