SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002931s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41995 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41995 [ RunTime:0.003707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (462279,323362,548346,478130,665135,512379,885708,1008179,1000218,174303,657171,128857,350835,730907,51509,446433,353375,575533,281526,19511,1035390,867256,297611,21243,616719,184416,757432,115634,565377,605216,331541,1023828,392661,480323,279613,385056,961318,851717,501336,899824,301741,59813,768640,885354,612862,22218,514967,446350,679859,422483,152370,610791,341798,626282,767047,110835,475591,678488,334507,693235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41995 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41995 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]