SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502955 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502955 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (220343,983780,257317,802066,867704,655856,279655,845244,1003121,585245,983235,437242,37460,172060,526197,533585,581632,407932,593240,613883,361576,757181,105413,880155,338233,948612,479869,591830,262426,56050,1040664,623468,412127,580803,701445,848515,429993,343386,303192,112951,438638,273664,806308,773032,179026,29669,252250,778181,455598,330643,918646,850215,279958,415948,79546,355077,312144,856572,953659,254242) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001772s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502955 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001864s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502955 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]