SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017992 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017992 [ RunTime:0.001628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (89205,296901,872299,104825,626744,281821,329240,549547,79980,95108,566643,863704,872575,691045,34019,176696,532296,747190,643991,256572,693266,141304,449077,330714,583199,989123,607701,100277,205210,145177,689343,236003,679549,1039155,458315,515096,610593,895171,558445,151332,59383,99151,518185,175163,858887,32409,435447,41813,458497,755888,871156,966465,601765,971677,710843,701160,1043895,530104,516937,769048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017992 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017992 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]