SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 651528 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 651528 [ RunTime:0.001606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (63301,824563,468838,346182,174311,840007,108527,274441,829570,494786,709972,308864,1046717,57353,872803,176318,959550,380167,752442,685994,574571,938489,697503,115694,649082,721146,293588,116179,575068,1033670,138151,782573,221188,11345,16132,482344,139083,822934,752742,435435,393963,284474,410040,846116,276090,212714,33219,971157,962020,38909,581188,146433,992801,296765,821327,796019,577560,268571,240126,76208) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 651528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 651528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]