SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103209 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103209 [ RunTime:0.001602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (811823,634242,207792,214074,256015,105625,890719,644138,201866,122344,803011,712089,138505,209420,379174,260297,750314,502816,456446,1016907,850797,514205,527319,394032,364284,67447,550878,868326,273159,523281,218370,68496,511946,282947,665108,333169,493852,829592,999264,606491,69362,580567,464927,136448,322993,234995,263588,852193,656512,967802,992617,44507,685996,361903,287472,593477,890731,780346,542781,755903) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]