SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335571 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335571 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (886768,635145,969498,578955,58302,509569,423864,760419,837197,814154,943149,623540,413331,639865,484154,495090,119322,629787,495305,144151,427960,182646,390619,390010,48391,431398,1009874,146338,733480,452102,902119,71304,649327,38274,448798,944284,617536,155148,1039560,680308,494158,551865,521031,702889,657974,395949,874184,39812,99353,596451,1013634,177173,364923,182672,438263,839186,889181,136403,269004,55701) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]