SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017882 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017882 [ RunTime:0.002163s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (860535,983988,271753,99196,167848,484591,981221,700823,824633,187309,18599,791026,756404,173326,429225,760325,1011904,282530,914568,392602,785854,361765,805028,355882,799172,813662,54159,513234,79901,548384,206024,343425,462874,961916,172691,321631,678853,313335,884013,351187,73085,6674,835504,816116,203449,966451,538349,1014074,438888,731223,145178,306182,154598,449046,801997,321372,878556,666620,983141,324692) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017882 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017882 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]