SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002708s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440802 LIMIT 1 [ RunTime:0.001770s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440802 [ RunTime:0.001948s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (813221,860231,406258,275023,240839,350813,416149,933703,905969,125518,333281,585336,190714,526287,8554,404588,665736,918468,371319,797962,209217,518418,697527,597297,976546,31637,558741,653152,700206,212399,150353,713787,173331,780955,331429,313298,700034,12532,319014,90613,780107,115162,773738,367120,1014094,679331,847616,846353,465773,991194,503976,125813,24986,617110,844039,693964,189718,801499,104755,380052) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440802 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440802 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]