SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002338s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450841 LIMIT 1 [ RunTime:0.000965s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450841 [ RunTime:0.002212s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (416981,574607,754983,813764,350213,612485,38191,136419,562524,30110,628237,91233,770763,46776,531637,319458,72315,807597,933692,869668,378200,305389,293809,335297,614109,988926,123210,199550,555791,545267,1044934,978102,815990,738197,456851,1043192,105588,721909,147206,996095,386019,519831,124978,849675,637387,618479,454716,152495,321248,248549,640514,254700,560904,394093,904402,964025,447907,932710,629288,17519) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001956s ]