SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001508s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 35739 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 35739 [ RunTime:0.004026s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (260694,690464,358076,544431,562437,661611,945863,1038812,140561,73876,684430,320390,906636,802415,690165,241002,248657,1005458,146454,947825,580439,265583,221974,914702,498123,228414,480628,50760,489417,620461,594826,304895,72990,103,865020,175512,78717,318559,681136,1011440,790975,41678,856074,821787,775735,511546,252251,826498,304735,772934,489138,542584,91802,412634,428021,678372,340053,592198,920530,628218) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003777s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 35739 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 35739 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002383s ]