SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491985 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491985 [ RunTime:0.003298s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530410,63620,602084,827151,880348,763657,375054,539181,702542,435450,323280,788123,176846,329960,817159,746079,889430,394987,908026,768946,910550,773371,559337,28529,889838,726075,133228,346694,795689,381726,403530,172856,933374,198222,77445,176534,821103,526971,450951,82340,1029409,229084,1005488,904703,196675,254466,789941,637026,448870,22748,548465,525146,317334,19316,177619,350140,741093,389836,915366,763438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491985 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000847s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491985 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]