SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002548s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 713550 LIMIT 1 [ RunTime:0.003130s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 713550 [ RunTime:0.005568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5108,943972,752816,126291,986589,423496,1013837,758214,270970,215985,32315,589926,290195,80138,61474,308780,443073,799037,273672,565820,648805,971474,162457,614734,576080,883263,646279,446347,775567,439813,992250,338181,599619,491171,24691,162210,571654,841285,822914,293936,886056,342912,151736,831984,498288,248328,303541,330824,644986,559188,154940,68207,400980,124962,835279,130004,471540,378626,415829,722470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002578s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 713550 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 713550 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001219s ]