SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301281 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301281 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (990732,368731,1032495,474784,715978,872922,1018177,40516,300425,560521,331803,349039,432934,686534,817224,408402,742347,807367,556576,93866,553784,142885,904246,664423,505765,876277,715497,869641,144447,17250,240488,526397,81771,249812,75235,747623,408519,318460,506600,366556,879511,345107,25910,563849,884649,764579,739267,727756,153779,379783,438079,433586,419730,922077,1036555,147927,984095,359555,426727,840056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]