SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480938 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480938 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (763440,374883,41409,348816,886341,858833,401195,572917,517481,11022,441954,764384,257206,190496,92499,796752,23777,942017,601173,781916,501200,296642,678647,944236,773465,861295,838994,84184,5542,960231,48831,190223,918376,121209,610673,372121,889872,866896,598044,989374,67487,79564,856286,866041,219246,1017838,647910,347553,69955,995038,741297,505038,67248,810448,915989,70173,804410,766051,50062,361263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480938 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480938 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001613s ]