SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481781 LIMIT 1 [ RunTime:0.004132s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481781 [ RunTime:0.004579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (348596,530125,859427,449760,980124,47302,950665,109456,767909,737662,946091,696944,747829,7,725829,406494,947393,763011,547933,456247,252782,722683,33515,258029,290264,461336,732820,900797,949713,245448,202928,969074,1019631,557479,448078,139585,225119,992610,572556,765231,676897,289876,347560,323693,762055,771128,793426,631239,290380,809885,831660,344433,7963,981865,825300,843520,859135,417487,609242,407004) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001294s ]