SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045569 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045569 [ RunTime:0.001767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (68954,820501,591004,496521,521863,868647,922740,303222,165689,414704,879101,325174,497783,687712,225088,71917,563477,627376,202036,973143,959675,335583,818966,435591,673443,623601,697354,236640,878416,266548,71924,44737,861150,370263,333986,94753,18821,137731,828825,181411,647132,281073,487194,1012828,881370,469694,370239,632467,785279,805017,747928,108000,234040,58685,322975,938492,816012,982326,769958,82340) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001714s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045569 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045569 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001856s ]