SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 181037 LIMIT 1 [ RunTime:0.001113s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 181037 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423581,438556,420255,53372,931859,709638,404834,44190,871571,26841,528862,913065,151842,537965,125680,26838,809108,784466,196694,519167,470271,133981,338792,732900,87329,1033188,295707,365934,484757,263365,807047,61791,214599,998180,271856,756216,674259,732735,379099,178550,69788,319927,884365,307035,361792,699430,940833,778183,970476,862673,861248,222008,250409,292756,900861,275278,90215,930336,357427,392419) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.028697s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 181037 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 181037 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001706s ]