SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416055 LIMIT 1 [ RunTime:0.000453s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416055 [ RunTime:0.001551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (754076,705507,248273,888362,201373,407244,243372,347841,212987,748186,276661,723826,738840,953515,8116,290244,823185,641111,969969,579985,486669,401680,1028445,411308,728676,701202,173561,66979,374012,695913,269964,34684,594472,774594,117769,886408,720094,955082,598162,54523,14895,902106,270156,360586,834813,765241,245272,621098,1000109,321210,8589,653030,742723,995163,228955,224289,760709,500467,977885,79237) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416055 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416055 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002916s ]