SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541112 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541112 [ RunTime:0.002256s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (290735,974179,949161,17720,993502,401474,210853,823312,404000,334369,592685,649864,133981,1021569,325612,89134,566936,153633,791381,69455,596725,814653,177563,374045,978671,447404,358468,661211,1026854,252851,501532,727803,31298,384955,141291,731020,345760,837715,684268,230792,228341,756831,289883,617948,470802,214759,690752,250125,658956,410933,853645,629378,2366,2196,394803,71466,592436,851282,522174,35624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541112 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541112 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]