SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 351418 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 351418 [ RunTime:0.002156s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (266937,358357,87225,131193,62919,444200,809716,520177,773482,783939,51805,881935,182296,959351,272135,157777,492011,251446,1032813,373015,209087,752189,1030607,825168,432680,388447,907920,640288,29960,578437,421565,21491,142304,356869,12481,287266,408545,197142,227842,94580,769082,361702,699764,602459,62607,545237,99451,748016,122982,78354,318931,672730,465574,856737,180017,122144,813925,634457,872807,620961) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 351418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 351418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]