SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 282048 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 282048 [ RunTime:0.002318s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (805075,799773,1035681,371694,176802,70158,653193,861789,294865,406704,909392,368996,146600,778654,507063,440612,949567,450221,403699,330491,939949,162280,869182,9117,361643,34862,370849,402002,158360,840844,510836,800448,315557,18480,410440,495137,1040643,929195,749443,879152,592943,209069,646781,546496,605285,43130,349167,683891,544899,467188,216747,104306,467850,450540,398350,22410,1030919,454479,960516,443648) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 282048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000749s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 282048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000678s ]