SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413918 LIMIT 1 [ RunTime:0.001496s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413918 [ RunTime:0.001825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (537728,296385,173090,735514,874318,434072,553964,575346,759876,348786,327628,1020346,910144,958985,577718,781205,335396,3194,624989,635227,915298,887623,913407,528985,718216,534858,901380,470572,231598,791347,215840,29727,92508,373820,273441,81460,832566,38128,256010,328491,843236,363796,880641,502615,610647,299030,379146,149455,1013234,490379,782310,427131,980587,661849,729582,362204,586869,655040,36522,1021397) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]