SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001965s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501184 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501184 [ RunTime:0.002391s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (822114,887674,373079,636085,424965,974452,428369,100962,753986,517643,657848,572607,240140,22546,914731,952873,863324,583674,176278,795917,279761,493737,885234,423732,479177,370105,616272,899262,1021109,298863,79562,459931,1017091,198146,617916,55416,419159,23116,232856,773288,764689,568751,151072,718623,102704,707703,385217,331650,514641,1015786,412892,170149,367237,242977,718564,660233,487332,956880,290891,891440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501184 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501184 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]