SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001397s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025022 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025022 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (903444,244829,205854,256980,166977,210044,639022,239378,780482,667702,869740,601346,702815,376965,588564,5783,316499,524619,245994,410848,754099,969277,961117,896995,411295,648420,823059,658027,972557,320575,299360,866453,380403,1029353,377850,145050,410621,631388,760809,983909,897258,632206,955982,142049,836518,295941,625525,177435,810313,568772,798871,558113,297595,233082,931907,401058,888795,856883,411667,266592) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]