SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005009s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012679 LIMIT 1 [ RunTime:0.001373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012679 [ RunTime:0.007457s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (461381,383030,798089,1036314,262163,819049,728148,1030759,687122,280384,511022,539660,674946,757465,763660,192273,339061,384735,704035,676314,1030950,712653,647,240990,97606,505066,203996,671720,800049,632890,859661,437853,439567,105,546183,201317,135874,513970,350788,147592,454744,252862,214829,916295,743918,197086,298787,227774,675982,647979,399094,495874,555234,405981,960242,575334,264246,380857,447332,191782) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004777s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012679 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002795s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012679 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001031s ]