SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 98158 LIMIT 1 [ RunTime:0.000467s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 98158 [ RunTime:0.001788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (373917,351678,305722,906090,889222,622166,241586,967107,640389,709180,838882,109339,461156,219538,227460,337777,24079,1008169,769824,681808,352927,318068,344278,100759,824243,786514,422874,262600,145243,905268,515630,381032,87497,419277,523441,168635,316430,301712,718792,297393,339058,949442,604321,342385,219686,968377,131415,569720,954241,474214,932864,520691,928271,720287,71659,848154,359521,935635,753403,861404) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 98158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 98158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]