SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404164 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404164 [ RunTime:0.001953s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (826648,921066,742033,445035,760958,334042,179831,504567,526374,690038,643350,493430,265107,315787,823940,178589,455602,290428,843389,678284,589188,639119,449148,1002347,68234,655717,41157,755636,561314,814902,294960,37314,192137,11985,512696,203397,777235,461029,117769,362130,274050,38643,1004828,525076,442553,148565,443236,188208,161369,567252,495925,972284,442142,540090,726320,851204,666969,544888,443107,328734) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404164 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404164 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006047s ]