SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001410s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 302014 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 302014 [ RunTime:0.003083s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (567694,608414,669128,853037,863707,730470,267514,496445,590632,109421,171987,124331,425692,1040030,784428,510988,287537,497866,718702,27611,587028,136130,758367,804336,409098,140633,306906,629985,554921,142943,789621,852534,468893,428773,120851,120309,919807,624649,621166,689098,896990,133361,355802,35351,948758,530179,767911,528549,892394,749374,1011727,645122,510452,460893,184369,191218,797005,9385,290716,879322) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 302014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 302014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]