SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498962 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498962 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269304,605599,380768,189993,505470,611610,258803,403433,429130,477951,940433,559690,966112,166141,52179,214374,580422,45619,476070,131981,703700,778140,458880,741129,203500,126921,140185,839928,918602,255216,1019297,810335,69152,434910,283920,221927,997854,306652,249072,325831,35093,77265,194364,951450,928867,798059,1033231,678977,982258,967335,516839,1024703,706728,133261,472056,516984,790739,545022,835061,828156) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498962 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498962 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002227s ]