SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504257 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504257 [ RunTime:0.005055s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (667093,493680,367660,68108,823423,392565,649839,112454,481151,507831,798048,305942,913339,200956,493095,950824,369420,409710,324433,334716,51807,102583,1913,454284,1018940,92897,165164,398405,772053,375704,278525,587620,739137,145104,14817,754189,846140,308713,676658,885939,223501,405430,774303,4194,688564,313549,723548,361963,161047,992147,597063,982970,492532,193290,558879,827505,296135,728705,70202,487667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504257 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504257 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]