SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415710 LIMIT 1 [ RunTime:0.000693s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415710 [ RunTime:0.004839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809214,634958,951083,1012193,595534,144426,137745,197259,46793,528071,962708,82932,771308,95112,867087,967283,871616,346614,695769,821978,938888,463165,715578,73065,480605,823602,781328,398432,289005,903064,1011767,879587,221261,35195,70293,382094,266395,328864,890282,87098,437913,112303,334344,105983,772322,201765,105191,812948,395148,62958,364458,963792,975431,709965,889757,111985,551191,269474,481137,240931) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000658s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000810s ]