SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025048 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025048 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (628012,214972,580312,690407,574958,901564,964861,117487,60599,129805,521673,347866,93154,687305,1024370,487977,975967,903042,246265,559936,79801,575061,42320,239426,573372,561692,837209,929128,329478,175461,794302,56748,628572,826246,756768,863033,290024,347981,726288,37620,955215,578092,1000372,25642,180733,766467,371435,799957,140188,666498,684521,965260,847020,603664,522321,815489,667005,330929,2797,771984) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]