SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 691938 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 691938 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532638,938474,908188,541413,530769,706478,115466,654058,102484,83472,424651,48472,311680,222887,136955,289426,268197,734419,756411,157316,979793,795615,975418,919285,379182,458937,337807,551508,20538,373063,430745,632702,1015058,566649,850147,512635,708555,175498,790975,993438,126263,689297,841366,258824,826864,180912,231221,475685,1773,664661,428122,207566,1042523,652032,443080,84217,296980,651554,983540,445587) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002301s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 691938 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 691938 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]