SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570834 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570834 [ RunTime:0.001839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (139841,16371,550415,755976,780423,391998,932056,317800,901170,737177,371244,151686,612620,80815,527216,659738,47777,223502,245382,383986,548586,142444,846086,628078,48074,3990,937093,1022514,1046098,331637,217541,1028168,660216,490019,632448,730001,325060,286862,890890,407398,568239,204524,371533,149676,8454,746984,528251,28067,726886,365379,91370,621849,1040645,823934,626323,816414,161299,607307,795609,605888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004637s ]