SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002534s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51701 LIMIT 1 [ RunTime:0.002137s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51701 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (866339,715924,461802,188503,222937,292073,995419,424986,691934,325462,289772,907327,661916,643802,87316,871932,772541,656499,29039,815380,147628,789258,120982,863722,247178,567204,975108,473343,978005,366139,356735,956332,253659,1025772,25968,637490,129289,679957,1047704,80662,1019863,561922,841545,179673,402608,716618,43077,898594,171917,571287,527206,633338,445102,87225,960126,854195,999898,811661,713000,789701) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]