SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001517s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 363511 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 363511 [ RunTime:0.001979s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (565404,246697,530536,540034,297225,420134,686451,634608,578459,859507,19172,402418,405111,447286,854243,169924,431764,490363,548165,268701,945576,253408,930103,442294,119665,728778,707977,894241,592237,342132,725219,483315,335489,901539,852141,805400,224154,614272,338721,787302,1027264,353537,999886,879391,342974,269837,30625,51710,168152,855953,14086,736783,983977,672597,622499,684605,410567,251938,327632,497470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001836s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 363511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 363511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]