SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 692743 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 692743 [ RunTime:0.002084s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (152229,892965,676551,595990,655449,442141,134814,746325,925168,541017,854894,183241,661028,642405,818677,193404,805099,206034,717057,728367,190819,594060,135548,555270,781522,784677,184346,361626,740036,187484,698539,508866,201178,975796,282050,163757,735603,732047,345458,230442,581156,542860,396069,191519,556706,892417,719214,246537,1020694,546607,723500,865977,223556,950512,183356,1037072,192505,259251,587177,783654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 692743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000816s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 692743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002192s ]