SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 84539 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 84539 [ RunTime:0.003922s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (358259,511682,374130,383600,717646,467752,406067,1009239,382303,772571,12440,818546,854769,454504,615599,1030365,161943,702721,299810,131978,97449,696421,296094,387057,728446,534590,762470,832600,439380,729957,430126,1038100,158139,251046,115534,154169,687267,223403,630417,288652,742320,58079,134779,625215,6701,49206,330890,900184,567129,981524,1035704,213116,755528,834527,284020,615065,101548,731187,571202,730667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 84539 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 84539 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]