SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596984 LIMIT 1 [ RunTime:0.000557s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596984 [ RunTime:0.001793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (71101,321625,2237,400986,761660,929838,204084,375302,1021394,566775,149010,989234,555552,293855,199873,268538,469072,398365,915724,976618,257674,921539,854034,260627,498377,59021,722053,175560,753141,782110,840079,675800,482343,868700,237252,701640,629874,518034,981632,317073,57483,321581,593618,574815,742394,891095,564590,854990,861641,864076,325677,497923,361221,975827,581845,996030,412793,190696,276637,1027886) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000667s ]