SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019676 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019676 [ RunTime:0.001789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016589,301879,707238,118214,1044077,741405,927910,845855,411305,72922,17665,1028003,180730,280635,370250,784338,956215,375815,386595,1034397,968782,197157,947151,944113,352919,323486,784665,773079,291446,919674,110801,908156,521939,66136,208735,373462,146177,636060,1024278,159582,558237,70695,510099,92640,394311,856567,639777,274328,168090,986201,12977,379463,385223,84804,714219,146092,686339,673095,369284,591730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019676 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019676 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]