SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031698 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031698 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005069,432317,657911,382340,416780,480397,543133,743426,344988,126022,264778,297419,713379,813797,816382,673,189599,769461,567819,479594,757166,913300,75471,821516,48686,524274,39551,336240,544060,946927,489705,42895,949656,272754,16881,608325,164322,762581,353014,127040,683301,3661,827912,442131,392854,1020438,889499,118257,1008498,623546,277470,839207,109563,723900,1039455,194421,812198,342633,970000,654898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000701s ]