SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50348 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50348 [ RunTime:0.001888s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (168091,985641,468280,541151,548273,918389,255437,217383,180213,118628,789693,711373,495994,785171,846130,473591,320192,531448,322541,181500,932589,376243,50629,162497,949536,143935,707035,554077,360767,990619,165537,6630,608811,26806,404515,1045880,606988,609701,753920,173176,732825,897668,654800,296311,700801,312605,55284,621861,429360,836631,558802,844850,190463,205838,517924,813906,357344,1039436,72210,990865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50348 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50348 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]