SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 687362 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 687362 [ RunTime:0.001843s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527443,444359,116004,448866,66019,99002,651828,839176,469220,1015129,639757,51668,807143,889611,424259,175191,814211,237249,10094,452528,203853,922210,513946,696426,761373,632582,450296,943898,820534,924597,399022,457695,287356,372581,332025,231522,968293,422460,194493,491974,947010,766880,759458,646447,483529,988133,740131,233524,54004,223123,991080,86145,154460,1000979,284398,301173,159894,457455,38610,313864) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 687362 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 687362 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002529s ]