SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 972828 LIMIT 1 [ RunTime:0.000539s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 972828 [ RunTime:0.002226s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (456297,162120,923797,843446,838594,731202,542756,148237,290238,844573,721268,670251,195180,331777,874871,582683,121568,62721,1001366,958442,538815,429797,416489,896130,57055,872771,631257,993106,360648,686484,828972,13394,950828,920330,49069,146742,236327,8937,520180,505935,375279,614641,231138,586734,959098,310446,868503,919165,829479,906952,886229,673458,185523,506103,360075,1027930,82652,615663,399399,811507) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 972828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 972828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002089s ]