SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532027 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532027 [ RunTime:0.002554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (438295,939065,444304,913614,1004415,682844,906575,59854,492604,976626,1036166,723408,824708,395987,897364,222518,145352,984808,809162,865633,1026890,302010,24565,333528,565974,365998,855189,150301,543369,433666,46414,302864,556490,902531,475766,105300,791118,146510,184665,305507,81283,917409,945676,488936,749924,1048015,28175,694525,726549,156116,21787,737224,98887,325612,92002,990670,1020736,847891,15384,959811) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]