SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280620 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280620 [ RunTime:0.001908s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (238731,168021,773241,71537,833067,23899,540955,931145,602978,105418,277144,5164,468133,761500,784029,797210,150698,61633,983739,900167,42164,849514,568502,52002,855370,421058,385699,778629,265054,590705,309100,103883,615331,198248,235750,920341,842632,901816,535580,263346,20166,762617,210477,230107,330763,173973,380614,320699,939681,205815,334727,207175,132303,873501,755746,864197,663909,434588,503221,811289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280620 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280620 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]