SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430079 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430079 [ RunTime:0.002015s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (330210,222489,702251,916550,979236,868260,289944,615667,868052,89577,41122,265335,568734,598344,871571,457271,34026,1007269,862844,127398,91520,1025599,738970,885201,691592,23342,985564,298694,294867,73040,133592,407625,933668,361638,383559,696210,682191,947166,438480,451228,336118,1031692,956198,772401,571097,401337,428583,265634,470478,341453,971998,689861,836225,216962,180861,536785,103205,707428,654863,485993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430079 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430079 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]