SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 163180 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 163180 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410545,221912,836,460871,643258,139702,213891,898853,665847,980940,108130,1003965,81536,750649,471819,804886,538104,428870,2146,668459,215623,981847,329952,863227,713004,273633,464620,586549,473795,250766,228071,714127,718733,246467,619359,398296,309980,219758,290982,246274,154604,634123,736985,458195,788251,283916,309376,511892,500012,760182,898507,417951,327446,107575,492863,366867,313618,579699,195691,457092) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 163180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 163180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]