SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196028 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196028 [ RunTime:0.001506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413303,677132,246103,627940,141266,510036,923432,878397,850222,59793,909251,213141,93013,401157,783716,971752,943944,772159,619511,721862,643318,165871,524185,491878,804173,556416,987830,163034,98370,19144,385390,624733,406030,265998,302774,498890,802461,336226,396449,894149,598405,710280,543911,481567,942827,431072,774359,913721,581252,1037958,560090,495257,1014892,511106,649477,540982,997781,685414,594663,639001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000941s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]