SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 250383 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 250383 [ RunTime:0.001807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501241,775297,475305,786384,722106,159496,311212,494390,42508,626588,558606,337565,53431,910175,708718,338153,19813,901882,615956,640814,269104,784878,173229,440474,512604,156887,66875,939948,1021755,489337,643056,1038413,489893,389652,819617,684907,744295,1031482,193736,418744,823424,614568,317973,748180,228029,982154,46772,216776,423090,47046,930880,373135,676832,889271,455639,686053,653367,301135,469011,506067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 250383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 250383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]