SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003698s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 2918 LIMIT 1 [ RunTime:0.001760s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 2918 [ RunTime:0.008154s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (541323,523680,57580,629965,239122,495159,610309,257512,418531,993493,86944,811177,72887,952779,58693,639240,758894,944756,1018637,786096,637350,286322,392979,44389,17186,526508,861043,798868,873485,797963,736518,69553,274197,42473,57445,856117,301083,470686,963375,727228,562529,739517,418585,582700,549639,976074,412090,389407,336106,728940,371442,650613,41683,927419,971026,383738,99061,541963,24786,898727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 2918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003732s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 2918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004942s ]