SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311721 LIMIT 1 [ RunTime:0.002444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311721 [ RunTime:0.002658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (205962,403531,1018414,839618,568515,728813,426787,509900,199989,989934,672351,298892,280348,183300,357388,273343,811954,595813,121822,859042,450873,579026,123542,320370,673139,107890,555935,523027,122888,794715,787767,410773,870306,307279,681160,601733,646578,420023,800448,430691,930989,794452,862811,928169,367998,460541,508368,579443,575078,854052,821356,106705,1022516,35359,74455,199615,715545,818596,563959,776820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311721 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311721 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001251s ]