SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001566s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 276901 LIMIT 1 [ RunTime:0.001795s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 276901 [ RunTime:0.004318s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504277,709778,42374,191335,443550,629538,763529,448696,850844,507413,398889,1041131,426985,1015285,287698,325993,711137,882128,818147,865887,693870,894641,680317,64957,910318,767011,572614,778841,559711,536344,831312,125031,895927,426949,795117,315633,311633,113384,207942,436967,1021333,613239,514839,708188,450691,206358,487836,383448,525958,128939,961134,611262,939784,170391,655756,186217,864057,892626,953081,118953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 276901 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 276901 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001516s ]